Find out which SQL Server instance is consuming most of the CPU

Posted on SQL Server Central See other posts from SQL Server Central
Published on Wed, 26 Sep 2012 06:00:00 UT Indexed on 2012/09/26 9:46 UTC
Read the original article Hit count: 216

Filed under:

We have a number of SQL Server hosts with multiple SQL Server instances. From time to time we have CPU issues, but we are not sure which instance is causing the issue. How do you find which SQL Server instance is causing CPU pressure on machine with multiple SQL Server instances? Check out this tip for ideas on how to find the correct SQL Server instance which is causing CPU pressure.

SQL Connect Keep your database and application development in sync
SQL Connect is a Visual Studio add-in that brings your databases into your solution. It then makes it easy to keep your database in sync, and commit to your existing source control system. Find out more.

© SQL Server Central or respective owner