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

image

image


Comments (0)

Skip to main content