erikdarlingdata/DarlingData

Question regarding sp_pressure detector sp

UriDimant opened this issue · 5 comments

UriDimant commented

Hi Erik,
Thank you for the update, I am using these procedures every day at work and it has been saved lots of problem to us. One question
My server is up time shows 12 hour (correct ) but in columns hours_cpu_time and hours_wait_time I see
35.49 and 53.6 , does it means 35 hours?
Can you clarify please?

erikdarlingdata commented

I’m not exactly sure what’s unclear, so I’m going to guess that you’re confused about those numbers being higher than uptime? Or is it something else?

UriDimant commented

Exactly, why those numbers being higher than uptime?

erikdarlingdata commented

Because you have more than one CPU.

UriDimant commented

Thanks , yep already realized that

erikdarlingdata commented

Great, so multiple CPUs servicing multiple concurrent queries (some may be parallel) can bump those numbers up much higher than uptime.