Buffer pool usage
Check buffer pool usage for every database. Returns information about all the data pages that are currently in the SQL Server buffer pool. Use output of this view to determine...
Posts related to SQL Server topics, divided to more subcategories by topic focus
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...
Force parameterization for query plan
Let your SQL Server know what query to parameterize if beneficial. When the PARAMETERIZATION database option is set to SIMPLE, the SQL Server query optimizer may choose to parameterize the...
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...
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...
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...
Generate persons test data
Quickly generate some persons data using popular AdventureWorks database sample. If you need to quickly test some functionality you would probably require some data for your tables. This script is...
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...
Add database role(s) in multiple databases
Add login to same database roles in multiple databases can be time consuming. You find this useful when you need to add some login to instance. Especially when application using...