• 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).