In a multi-instance cluster, how can you match a named sql server instance
with an instance of sqlservr.exe? When setting up counter collection in
perfmon, I choose the "process" performance object, then the "% processor
time" counter". In list of instances, I can see sqlservr#1, sqlservr#2, etc.
How do I know which named instance each of those represents?

TIA.

Hello

One way (I dont know if is the best way) is to match the ProcessID on
Process Counter from Performance Monitor to the ProcessID that is on the
ErrorLog from the Instance.

Something like:
PerfMon -> Process -> ProcessID -> Select SQLServer# on the instances.

Now go to SQL Server Enterprise Manager for each instance and look on the
ErrorLog for the line:
Server Process ID is 3636.

That should be easy if you need to do just on time.
--
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org


"Denise" wrote:

That's a good idea, thanks for the suggestion.

I don't have access to the error log on all the servers, but I can use
SELECT SERVERPROPERTY ('processid')

"Carlos Eduardo Selonke de Souza" wrote: