Top waits
Identify top waits occurring in SQL Server. Handy script with links to detailed information about given wait. Links pointing to great SQL Server Wait Type Library from SQLSkills.com. You will...
OH Index maintenance duration per index
Check which index's maintenance is taking most time. Short script to answer this question. It is part of script series related to popular Ola Hallengren's maintenance solution. If you are...
Execution count of stored procedures
Check what stored procedures are loading your SQL Server the most. Nice and simple analytical query to check which stored procedures are running most times. Its like small procedures competition...
Database statistics information
Query information about statistics in current database. You will get nice overview about all statistics and their properties in one table. It is important to keep statistics up to date...
Memory usage by memory clerks
Look under hood and check what clerks are using memory. The SQL Server memory manager consists of a three-layer hierarchy. At the bottom of the hierarchy are memory nodes. The...
Memory and page file usage
Check configuration and usage of RAM and page file. Useful as quick overview for memory performance problem entry point. You will see if SQL Server using all memory according to...
Get query completion – detailed
Retrieve information about query completion percent and estimated finish time. This is useful when running big databases restore or some hard DBCC database command. You want to check actual state...
Get query completion – simple
Retrieve information about query completion percent and estimated finish time. This is useful when running big databases restore or some hard DBCC database command. You want to check actual state...
Buffer pool pages distribution
Check page count stored in buffer pool for every database. Returns information about all the data pages that are currently in the SQL Server buffer pool. The output of this...
Data files latency
Examine performance of particular data files for all databases. Useful when troubleshooting performance of your SQL Server. Latency is one of the main performance counters measuring IO performance for SQL...