Single use execution plans
Get execution plans that were used only once. SQL Server from its nature caches all execution plans, even for queries that are executed once. This behavior can be suppressed by...
Get queries with same plan
Analyze plan cache for multiple use of plan by same query. Script is part of execution plan analysis series. You can use it to find how many plans generated by...
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...
Get cached execution plans
Look into your cache and see what execution plans live there. You can quickly identify what SQL Server stored in plan cache and see how many time was this plan...
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 usage
Check how are your indexes doing in the database. This script is very useful when you are doing some performance optimizations by creating new indexes. Or trying to find some...
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...