sys.dm_os_wait_stats is the key DMV for understanding wait stats. Day 3 covers the basics of this DMV and how its wait times can point to bottlenecks.
SQL SERVER – Signal Wait Time Introduction with Simple Example – Wait Type – Day 2 of 28
When do wait stats occur? Day 2 explains the running, runnable and suspended states of a query and introduces signal wait time with a simple example.
SQL SERVER – Introduction to Wait Stats and Wait Types – Wait Type – Day 1 of 28
Day 1 of my 28-day series on wait stats and wait types: how reader feedback and six months of tuning work led me to share these real world findings.
SQL SERVER – DMV – sys.dm_exec_query_optimizer_info – Statistics of Optimizer
The DMV sys.dm_exec_query_optimizer_info keeps statistics of optimizer activity. My simple query shows optimizations, elapsed time, final cost and more.
Page Density: The Fragmentation Number That Actually Slows Scans
Measure page density and fragmentation, compare scan reads around a test rebuild, and choose fill factor using workload evidence.
Recording Table Row Counts Every Day
Recording table row counts each day creates a useful SQL Server trend when a scheduled job, history table, and change review support it.
SQL SERVER – Finding Last Backup Time for All Database
A quick script I use to find the Last Backup Time for all the databases on my server, joining sys.sysdatabases with msdb.dbo.backupset.