• State Not Answered
  • Replies 5 replies
  • Subscribers 60 subscribers
  • Views 1933 views
  • Users 0 members are here
Options
Related

SQL PI

mbradley
over 1 year ago

Am I correct in assuming that the chart scale in SQL PI (seconds/s) is seconds per session?

Parents
  • 0 over 1 year ago

    Hi, 

    The seonds/s metric is seconds per second. It represents the number of seconds of db workload (cpu usage + wait time) per second (time).

    If you had a single CPU instance you would have 3600 seconds of compute available each hour. If you had queries using all of the CPU, it would average 1 second/s

    If additional SQL starts waiting on cpu or other resource, that graph starts to climb.

    In multi-core servers, you will have "core count" x 3600 seconds available each hour for CPU.

    There's also a support KB available here with additional explanations.

Reply
  • 0 over 1 year ago

    Hi, 

    The seonds/s metric is seconds per second. It represents the number of seconds of db workload (cpu usage + wait time) per second (time).

    If you had a single CPU instance you would have 3600 seconds of compute available each hour. If you had queries using all of the CPU, it would average 1 second/s

    If additional SQL starts waiting on cpu or other resource, that graph starts to climb.

    In multi-core servers, you will have "core count" x 3600 seconds available each hour for CPU.

    There's also a support KB available here with additional explanations.

Children