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

Answers

• Options

  Russell D Redgate › Posts: 1,324 Diamond 5

  May 10, 2019 8:42AM

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

  Have you visited our Help Centre?

  0 · Share on Twitter
• Options

  HHT Posts: 3 New member

  May 10, 2019 10:17AM

  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?

  0 · Share on Twitter