SQL Database WAIT STATS


–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

 

 

 

 
 

 

 

 

 


Comments (0)