Missing Perf Counters

I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!
Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/FA...rCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>
|||See below URLS as well.
http://sql-server-performance.com/fo...p?TOPIC_ID=695
http://sql-server-performance.com/fo...p?TOPIC_ID=308
http://sql-server-performance.com/fo...p?TOPIC_ID=687
http://sql-server-performance.com/fo...p?TOPIC_ID=907
http://sql-server-performance.com/fo...p?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>
|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:

>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>