CPU Drill-Down Feature in Database Health Monitor
A powerful updated capability has landed in Database Health Monitor, and it’s all about making CPU troubleshooting faster and more intuitive. For years, DBAs have had access to two valuable—but separate—views: CPU by Database and CPU by Query. Each report offered useful insight, but there was no direct way to connect them. Until now.
The Problem: CPU Reports Without Context
Previously, the CPU by Database report made it easy to see which database consumed the most CPU, but not why. Similarly, CPU by Query showed the biggest CPU offenders but didn’t identify which database they belonged to. Without a connection, DBAs had to manually correlate the data.
The Solution: A One-Click Drill-Down
With the new enhancement, you can now click directly from the CPU by Database report into the associated CPU by Query report. This instantly surfaces the exact queries causing CPU pressure within that database.
Why This Matters for Troubleshooting
This small change delivers a major efficiency gain. Instead of jumping between reports and making assumptions, you can now follow a clear path: high CPU database to specific CPU-heavy queries to targeted tuning. It’s the kind of workflow improvement that saves hours during performance investigations.
A Real Example
On a test server, the DatabaseHealthHistory database appeared as the top CPU consumer. With a single click, the new drill-down reveals precisely which queries inside that database were driving the usage—making root-cause analysis fast and straightforward.
Try It Today
We encourage you to download the latest version of Database Health Monitor at http://DatabaseHealth.com and explore the new CPU drill-down feature yourself.
And, as always, if you want ongoing performance monitoring, tuning, and expert oversight, our SQL Server Managed Services provide complete SQL Server care, including proactive performance troubleshooting. Visit https://stedmansolutions.com/managed-services/ for more information.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!