Question regarding sp_pressure detector sp

erikdarlingdata / DarlingData

Open source SQL Server nonsense: sp_PressureDetector, sp_QuickieStore, sp_HumanEvents, etc.

https://www.erikdarling.com/

MIT License

443 stars 132 forks source link

Question regarding sp_pressure detector sp #411

Closed UriDimant closed 2 months ago

UriDimant commented 2 months ago

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 2 months ago

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 2 months ago

Exactly, why those numbers being higher than uptime?

erikdarlingdata commented 2 months ago

Because you have more than one CPU.

UriDimant commented 2 months ago

Thanks , yep already realized that

erikdarlingdata commented 2 months ago

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