How can we help you today? How can we help you today?

Waits stats says SQL are waiting 3000ms/s on a 4 core system. This means 3 of 4 cores are waiting?

If wait stats says you SQL Server is waiting 3000ms/s on a 4 core system. This means 3 of 4 cores are waiting at this point?
Hans
0

Comments

2 comments

Sort by
  • Russell D
    Broadly speaking, the waits is just the total time something is waiting, you have to divide it by the number of cores to see what impact it may actually be having. This is a great guide:
    https://www.brentozar.com/archive/2015/03/how-to-measure-sql-server-workloads-wait-time-core-second/.
    Russell D
    0
  • HHT
    Hi, thanks I know that I have to divide waits stats by the number of cores to get a understanding of the impact. But I am asking based on the TOP graph in SQL MONITOR where one of the grafs are WAIT stats, with unit ms/s. Is this wait stats in SQL Monitor divided by the number of cores?
    HHT
    0

Add comment

Please sign in to leave a comment.