(SQL) Tip of the Day: Analyzing Wait Types

Today’s (SQL) Tip…

Today I would like to talk about sys.dm_db_wait_stats. This DMV lets you get the wait stats from your SQL Azure Database, and for those of you familiar with it, it is the replacement for sys.dm_os_wait_stats from on premise SQL Server. This query gives you average waits per query which is great if you are running into query timeouts on your database. Look for any averages near 120 seconds as SQL Azure times out a query after two minutes.