| Author |
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\sq
lctr.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!
| |
| Jerry Spivey 2005-09-29, 8:23 pm |
| 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/F...erCounters.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\sq
lctr.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!
>
| |
|
|
| Sue Hoegemeier 2005-09-29, 8:23 pm |
| 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\sq
lctr.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!
>
|
|
|
|