How can I find out what process is consuming all the CPU resources on my SQL Server? (4317543)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How can I find out what process is consuming all the CPU resources on my SQL Server?
Description

How can I find out what process is using all my CPU and Disk resources on my SQL Server?
Resolution

On the SQL server with the Archive Manger database open SQL Management Studio, click the New Query button and enter the following command.
sp_who2
This command lists all current processes connected to a SQL Server along with thier CPU time and Disk IO.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title