CPU By Query
The CPU by Query report helps identify which SQL queries are consuming the most CPU time. It provides a breakdown by object name, execution count, average CPU time, and the time of last execution. This report is critical for performance tuning, resource planning, and avoiding outages caused by CPU bottlenecks.
Why It Matters
High CPU usage is often caused by a few inefficient queries or high-frequency jobs. The CPU by Query report helps:
- Pinpoint problematic queries
- Identify inefficient monitoring routines
- Compare workloads across different databases
- Provide actionable insights for tuning
Report Columns
| Column Name | Description |
|---|---|
| Object Name | The name of the stored procedure, script, or module being executed. |
| Total CPU Time (ms) | Total CPU time consumed across all executions of the query. |
| Execution Count | The number of times the query has run. |
| Avg CPU Time (ms) | The average CPU time per execution. Useful for identifying expensive calls. |
| Last Execution Time | Timestamp of the most recent execution. |
| Query Text | A portion of the actual SQL statement that was executed. |
The top portion of the report displays a color-coded bar chart ranking queries by total CPU time. Each row represents a separate query or component.
Need Help?
If you’re not sure how to interpret the data or what to fix, we can help. Whether it’s a confusing execution plan, unexplained CPU spikes, or just too many scheduled jobs.