Sometimes SQL goes to 80–90% CPU “out of nowhere”
because stats are stale.
✔ Emergency Fix:
UPDATE STATISTICS Orders WITH FULLSCAN;
💡 Why It Works
The optimizer chooses WILDLY wrong plans if statistics aren’t fresh.
⚠ Pro Tip
If your DB is huge → don’t FULLSCAN often.
Use:
EXEC sp_updatestats;
Much lighter.