• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

Can we Identify the CPU resources used by each sql named instance on a single Server

Hello Experts,

I have 2 named instances (SQL Server 2008 SP2) on a single physical server.

Can you please guide me if there is a way to identify amount of CPU resources used by each instance.

I am trying to estimate the CPU usage of each instance to get a baseline for migrating one instance to different server.

Thanks,
0
dba2dba
Asked:
dba2dba
2 Solutions
 
dodge20Commented:
Sounds like a job for perfmon.

I believe they counters you are looking for are in the resourse pool stats, cpu usage % or something similar.

So for a default instance it would be SQL Server:Resource Pool Stats
For a named instace it would be mssql$instancename:Resource Pool stats
0
 
louisreevesCommented:

Here is a good link that shows the basics on how to find the high CPU culprit on a per instance basis
http://jeffstevenson.karamazovgroup.com/2008/09/identifying-high-cpu-sql-processes.html

However, you can also run the following command to pull up the intances in the command line below
(assume the instances are runnning on port 1433:
netstat -ano | findstr "1433"

if you stop one of the SQL instances and run the command you can find the "known" spid (THe SPID is off the the far right) of the instance that is still running. Then start the other instance and run the command again. now you see two entries. You also have the SPID of the second instance.

With this information you can use the task manager to see which instance is using the CPU.  In the task manager, go to the process tab and click the view -seclect colums option. select the PID (process identifuer), CPU usage, and any other counters you wish. -  you can get a rough and tough estimation of the CPU usage, isolated by the PID you have collected from the prevous steps.

I hope this helps.

L  



THen start
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now