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