question

adiso75 avatar image
adiso75 asked

SQL Server Waits report

Hello In the management studio there is a chart called SQL Server waits (Data collection --> Reports --> Management DW --> Server activity history) and I'm trying to figure out what is the Y Axis represent. it says "ms/sec". What does that mean? is this an accumulative number? Essentially I'd like to know how much time (in second) sessions where waiting for a given wait Thanks
performancemanagement-studiowait-type
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
That's showing the amount of time that waits have occurred for the time period measured. So it's not cumulative, it's a measure of waits sampled. If you look at sys.dm_os_waits_stats (or sys.dm_db_wait_stats in Azure SQL Database), you're seeing only cumulative waits so you have to compare one sample to another to see the change over time. The report you're looking at is showing the change for you, so waits that occurred for that time period.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.