CPU Time Percentage Used alarm is active when the stress on the processors for the specific SQL Azure connection exceeds a threshold. This value is calculated over a specific number of background collections. Sustained high CPU utilization can adversely affect the performance of SQL Azure.
When the alarm is raised
- Look at the SQL Azure | Workload Analysis drilldown and select the CPU resource to see possible causes of high CPU usage.
- Look at the SQL Azure | SQL Activity drilldown | Sessions page to see which SQL Azure users are currently running SQL, and to determine the exact SQL that is running. If necessary, use the Session Trace sub-tab on active sessions.
The system will calculate an equivalent CPU usage value based on the stress experienced by the processors in the environment where the specific SQL Azure is deployed.