How to check the free space and Usage of ASM Disk Group
How to check the free space and Usage of ASM Disk Group In this post we have provided 2 scripts , 1st to check the Usage of each ASM disk… Read more »
Author Archives: Pankaj Yadav
Find out the Owners of SQL Server Agent Jobs Using TSQL
Find out who are the owners of the SQL Server agent jobs with the help of below script. SELECT J.name AS [Job Name] ,L.name AS [Job Owner] FROM msdb.dbo.sysjobs_view J… Read more »
Select Size of All sql server Databases
How to select size of all sql server Databases Below script will select the size of all your SQL Server databases in MB and GB as well. SELECT d.NAME ,ROUND(SUM(CAST(mf.size… Read more »
How to check index fragmentation on all indexes in a SQL Server database
Check Index Fragmentation on ALL Indexes in a Database I use to make note for my self so that I can recall it quickly! when I am using a development… Read more »
How to display Report Generating user name at the SSRS Report Footer
Displaying Report Generating the Date time and user name without Domain or System name: 1- Go to Design mode and Create footer in SSRS report 2- From The toolbox add… Read more »
Sql Server 2019 Compatibility
COMPUT Clause is not allowed in Database Compatibility 110 Issue Details- Impact- The COMPUTE clause generates totals that appear as additional summary columns at the end of the result set…. Read more »
12 ways to speed up Windows 10
If you want to Speed up your Windows 10 OS, take a few minutes to try out these tips to speed up your PC and make it less prone to… Read more »
How to Resolve Lag and Unstoppable OGG Extract process
ERROR OGG-15163 There was a problem sending a message to EXTRACT (Timeout waiting for message) The EXTRACT looks hung, but its status is still showing is “RUNNING”. Restarting the process… Read more »
Query to check tablespace size and freespace
select b.tablespace_name, tbs_size SizeGb, a.free_space FreeGb from (select tablespace_name, round(sum(bytes)/1024/1024/1024 ,2) as free_space from dba_free_space group by tablespace_name) a, (select tablespace_name, sum(bytes)/1024/1024/1024 as tbs_size from dba_data_files group by tablespace_name UNION… Read more »
Tablespace usage monitoring script
set feedback off set pagesize 70; set linesize 2000 set head on COLUMN Tablespace format a25 heading ‘Tablespace Name’ COLUMN autoextensible format a11 heading ‘AutoExtend’ COLUMN files_in_tablespace format 999 heading… Read more »