The top consuming process is a native Windows process Check the MSSQL Agent logs toĭetermine if this is the case. High CPU usage with MSSQL Server can occur if a Job or a large user query is currently running.
The top consuming process is MSSQL®SERVER (The SQL server process for a database instance) If you don’t expect this increase, check the IIS connection logs to get more information about the source of the excess traffic toĭetermine if you want to block these connections. If you expectĪn increase in traffic and you notice performance degradation, alleviate the server load by increasing the resources on the server. High CPU usage with the IIS worker process typically occurs when higher than normal traffic comes to your website.
You can determine the best path to resolve or prevent high CPU usage, depending on the process causing the high CPU usage.įollowing are a few examples and some general recommendations to help you resolve high CPU usage: The top consuming process is w3wp (IIS Worker Process) On your environment, start looking at these top processes when determining the cause. Ensure the arrow that appears on the header pointsĭown so the data is sorted from highest to lowest. Note: You might need to maximize the window to see all the data.Ĭlick the Average CPU column header to sort by overall CPU usage.
Type resmon in the text box and press Enter to open Press WIN + R on the keyboard to open the Run dialogue. Use the Resource Monitor to view CPU consumption If any of these processes are higher than expected based The processes consuming more resources display at the top of the list. Ensure the arrow that appears on the header pointsĭown to sort the data from highest to lowest. If you see a single list of tasks in the Task Manager window, click the More Details arrow to show the expanded view.Ĭlick the Processes tab if it is not already selected by default.Ĭlick the CPU header at the top of the table to sort by CPU usage.
To access Task Manager, right-click the taskbar and click Task Manager. Multiple methods allow a user to determine the top processes based on CPU utilization. This article helps you determine which application is causing high CPU usage on your server. This article applies to the following Windows® Server versions: 2012, 2012 R2, 2016, 2019 Overview
0 kommentar(er)
