Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 performance counters problem

Author  Topic 

kokanidja
Starting Member

5 Posts

Posted - 2011-11-02 : 05:10:18
suddenly my sql counters give me all zero as a result. why?
only counters that are working are system like procesor, disk..sql counters are there to be added but when i run it it just gives me zero value. :(

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2011-11-12 : 05:28:53
One suggestion is to rebuild the performance counters.
Have you recently reinstalled or selected Minimum installs?
An example of rebuilding is :

lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini"



Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -