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.