-
Missing counters in Performance Monitor
Im missing all SQL Server counters in the Performance Monitor
and have looked at article: http://support.microsoft.com/default...NoWebContent=1
but this article refers to SQL 7...I have 2K with SP3 and MS03-031
How can I get my counters ? thanks
-
Follow the instruction in the article to add counters. The .ini file is located in
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
-
I found 2 filesne is called "sqlctr.ini" and the other is called "sqlctr.h"...should I just delete the sqlctr.h file ?
and why would it have an extension of "h" ?
Last edited by kim; 08-20-2003 at 03:25 PM.
-
Use SQLCTR.INI with loadctr.
-
.h files are C or C++ header files.
This file has all constants.
If you open the file you can see the following lines
// This file is generated by the description file processor.
// Please do not edit.
-
Last edited by kim; 08-21-2003 at 12:13 PM.
-
-
I opened the cmd window and changed the directory to where the sqlctr.ini resides (D:\Program Files\Microsoft SQL Server\MSSQL\Binn)
then ran "unlodctr mssqlserver"
then ran "lodctr D:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini"
then opened and closed performance monitor...but still cant find my counters ?...any other ideas ?...do I need to stop and start SQL Server ?
thank you
-
In addition I found this msg in the sql server log:
"performance monitor shared memory setup failed: -1"
any idea if this is related ?
-
Yes, have to restart sql service.
-
the counters are still not showing up
-
Did you reboot the server or just restarted SQL Server?
Check if the counters are listed in registry
http://support.microsoft.com/default...;en-us;q127207
-
thank you, but that article applies to NT...whereas I have Windows 2K server
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|