Once you connect to your SQL Server or Azure SQL instance, you can select Reports > Performance Dashboard and see the current and historical values of CPU usage. Here you can find the query texts of the top resource consumers and identify the queries that are causing the CPU issues.
How do I check CPU usage on server?
Use the Resource Monitor to view CPU consumption
- Press WIN + R on the keyboard to open the Run dialogue. Type resmon in the text box and press Enter to open the Resource Monitor.
- Click the CPU tab. ...
- Click the Average CPU column header to sort by overall CPU usage.
How do I find my CPU bottleneck in SQL Server?
You can use Performance Monitor to check the load on your CPU. Look for the Processor:% Processor Time counter: if it regularly exceeds 80% of the processor time per CPU then most probably you're facing a CPU related bottleneck. Some of the CPU intensive operations are compilation and recompilation.
