Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rikleo2001
Posting Yak Master
185 Posts |
 Posted - 2009-02-10 : 02:55:23
|
| HiMy company has multiple SQL 2005 instances on Shared Plateform (Windows with 16 CPU) Everybody single instance is sharing all 16 CPU. Now I have been given task to track the performance of one of application linked on one instance which shares all 16 CPUsNow I have profiler running with default setting only for that SQL instance, and to correlate data from Perfmon, I configure specific SQL objects and some specifc system object counters, now I am confued with CPU (Process or Processor % Processor Time counter)In shared enviornment how should I track CPU utilization for one single SQL SERVER Instance?Any expert advise?ThanksSKR |
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-02-10 : 08:21:43
|
| How about perfmonperformance object - processselect counters from list - % processor timeselect instances from list - choose you sql server instance processThanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
 |
|
|
rikleo2001
Posting Yak Master
185 Posts |
Posted - 2009-02-10 : 10:01:58
|
| That is great, but how can I find which instance is running on which index, currently I have 14 instnaces.So the question is how to identify which instance is on which index in perfmon?Thanks in advanceSKR |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-10 : 10:06:09
|
quote:
Originally posted by rikleo2001
That is great, but how can I find which instance is running on which index, currently I have 14 instnaces.So the question is how to identify which instance is on which index in perfmon?Thanks in advanceSKR
What do you mean by Index in instances? Can you explain? |
|
|
|
rikleo2001
Posting Yak Master
185 Posts |
Posted - 2009-02-10 : 10:18:24
|
| Well, in Perfmon, under process-> % Processort Time, then on right hand side I see list of instances (lots of entries including (sqlservr,sqlservr#1,sqlservr#2 upto sqlservr#13), Now if I look at my SQL Server 2005 configuration manager I see list of named instances (ABC, XYZ, YYY), now How would I know which on in Perfmon should relate to named instance, so I can track the right instance out of 14.I hope this explains, if not please let me know...SKR |
|
|
|
|
|
|
|
|
Multiple instances on Shared Platform