Performance Counter Problems

Hi,
We are running SQL Server 2000 SP3a on Windows 2003 Server.
I use the Performance Log to capture some performance counters and saved
as text file. When I opened the captured file, I discovered that the
SQLServer Counters are not recording anything (\SQLServer:Memory
manager, \SQLServer:Buffer manager, etc ) But other counters like
\Physical Disk: %Disk Time, \Processor:%Processor Time are recording
values.
I will appreciate your help.
Thanks
Egbon
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!"Egbon V." <vnjowusi@.gosps.com> wrote in message
news:eXySJtO7DHA.2656@.TK2MSFTNGP11.phx.gbl...
> We are running SQL Server 2000 SP3a on Windows 2003 Server.
> I use the Performance Log to capture some performance counters and saved
> as text file. When I opened the captured file, I discovered that the
> SQLServer Counters are not recording anything (\SQLServer:Memory
> manager, \SQLServer:Buffer manager, etc ) But other counters like
> \Physical Disk: %Disk Time, \Processor:%Processor Time are recording
> values.
This article looks promising, it may be a WMI registration issue:
http://support.microsoft.com/defaul...0&Product=sql2k
Steve|||Steve,
Thanks a lot!
Egbon
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!sql