Script Rebuild Index Depending on Fragmentation
The below script rebuild all the indexes that are fragmented higher than 30%. Reorg indexes that are fragmented between 10%-30% -- Ensure...
Script Rebuild Index Depending on Fragmentation
Buffer Pool Extension
Find Top 50 SQL statements and SP with highest workertime and execution count.
Query to find Storedprocedure with the highest total workertime in SQL Server
SQL Server object with most latch contention
Table Used most in SQL Server
Find Storage Latency in SQL Server
SQL Server Page Split/Sec using DMV
Find who uses the most query memory grant in SQL Server
SQL Server Average Stall Per IO
Query to find page life expectency in SQL Server
551-554-7088
©2019 by SQL Server Database Administrator. Proudly created with Wix.com