September 5, 2002 at 9:52 am
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.
September 5, 2002 at 11:02 am
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy