--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