Hi,
I have a default sql instance and 2 named instances on the server.
The PID's of the sqlserver.exe are 1672, 1644 and 1816.
The performance counter is Process, %processor time. (not Processor, %processor time)
Then you can select 'instances of selected object (= which process you want to monitor) where I find sqlservr, sqlservr#1 and sqlserv#2.
So I would like to know how to match the 'instances of selected object' from counter Process - %processor time to the sql instance names (or the PID's of the sqlserver.exe).