SQL Server DBA

DarlingData (Erik Darling)

Question

sp_PressureDetector versus sp_PerfCheck: when should each be used?

Answer

sp_PressureDetector detects CPU and memory pressure from waits, file stalls, memory grants, thread usage and currently executing queries. sp_PerfCheck is a comprehensive performance health check. Use PressureDetector during an active slowdown and PerfCheck for a broader, non-urgent performance review.

This is 18 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples