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...
Plan cache distribution per database
Check what database is using most of plan cache. Every query execution requires execution plan. Execution plans are in most cases then stored in plan cache for reuse. This behavior...
Shrink log for all user databases
Bulk shrink of transaction log for all databases. This script is handy when your transaction logs grown big on several databases. You want to shrink all log files quickly so...
TempDB configuration check
TempDB is heavily used database in every instance, time to check it. As every DBA know TempDB database is shared for all sessions within DB engine. This makes its performance...
Update statistics for all databases
Easily update statistics with one line function. I know that you are maintaining statistics by some maintenance jobs scheduled to run on regular basis. You can use builtin Maintenance plans...
Index list
Get information about all existing indexes in given database. This script can be handful when you want to check all indexes with their create scripts and some of useful information...
Optimize for Ad-Hoc Workloads
SQL Server is using part of its memory for storing execution plans of the queries that can be used repeatedly without recompilation. Every compilation of execution plan has its cost...