Named instances not showing in Perfmon - SQL2K-sp3 running on Win 2K Advanced Server
Posted on 2006-07-11
The SQL server has three instances:
the default instance (server1) on port 1433 - which is not used in production,
named instance 1 (server1\nc_gp) on port 1443 - heavily used, and
named instance 2 (server1\nc_qc) on port 1533 - moderately used.
In perfmon I see only "\\server1" in the "Select counters from computer" drop down. When I add the Performance object [SQLServer: General Statistics - User Connections] it shows 2 connections, which is what is coming from the default instance. The named instance "server1\nc_gp" has >100 connections according to sp_who2 and SEM. I've tried typing "server1\nc_gp" and "\\server1\nc_gp" in the "Select counters from computer" drop down and then clicking to Add the desired performance metric, but it throws an "unable to connect to machine" error. The "Select instances from list/All instances" radio buttons are greyed out. Beating my head against the wall for hours on this. Ideas?