SQL Database WAIT STATS

  • Article

--SQL Database WAIT STATS
--New for SQL Database (Windows Azure SQL Database) are database level WAIT STATS.  These are executed against the application database, not the MASTER database.
--Retrieve cached performance WAIT stats by database
--dm_db_wait_stats

 

SELECT * FROM sys.dm_db_wait_stats
ORDER BY wait_time_ms desc

  

wait_type waiting_tasks_count wait_time_ms max_wait_time_ms signal_wait_time_ms
--------------------------------------------- -------------------- -------------------- -------------------- --------------------
LCK_M_U 7 640004 225320 0
ASYNC_NETWORK_IO 12508 62532 192 345
PAGEIOLATCH_SH 1100 10999 1362 69
SE_REPL_COMMIT_ACK 2029 7551 244 372
SE_REPL_SLOW_SECONDARY_THROTTLE 30 7356 1178 10
SOS_SCHEDULER_YIELD 8915 1799 15 1778

 

 

 

Chris Skorlinski
Microsoft SQL Server Escalation Services