Using Performance Monitor with Multiple Instances

• rayboyle

  SSC Enthusiast

  Points: 160

  More actions

  September 5, 2002 at 9:52 am

  #105191

  I have a Windows 2000 Server on which 2 instances of SQL Server are running. The default server is a SQL Server 7.0 along with a named instance of SQL Server 2000. When I run Performance Monitor, I can only select counters for the default server. Is there any way to see counters for the named instance server.

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  September 5, 2002 at 11:02 am

  #436007

  So you aren't seeing Performance objects for MSSQL$<Instance Name>? Typically they should be there, though Books Online I think misnames the objects.

  If they aren't there, take a look at the following KB article to see if you are getting some of the errors in your event log:

  http://support.microsoft.com/default.aspx?scid=kb;en-us;q227662

  K. Brian Kelley

  http://www.truthsolutions.com/

  Author: Start to Finish Guide to SQL Server Performance Monitoring

  http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

  K. Brian Kelley
  @kbriankelley