Rebuild master.dbo.sysperfinfo

On further study I've found that the sysperfinfo table on
the servers with the missing Performance Condition alert
type is EMPTY. I know that on one server with this
condition I upgraded from Standard Edition to Enterprise
Edition, but don't know what caused the server to lose the
data in this table.
Can anyone tell me how to rebuild the data in this table
safely. I know I can't just copy it from another server.
There's nothing in the BOL on rebuilding it.
Any ideas?
Allen White
Sr. Database Administrator
Advanstar CommunicationsThe system table master..sysperfinfo is a virtual one which is dynamically
maintained by SQL Server. So you cannot manually update them as you wish.
Also, it is possible that the SQL Server is started with a -x switch which
disables certain internal statistics. There are many reasons why you do not
see any performance monitor counters, some of which are detailed below:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246328
http://support.microsoft.com/default.aspx?scid=kb;EN-US;127207
http://support.microsoft.com/default.aspx?scid=kb;EN-US;227662 (old)
--
- Anith
( Please reply to newsgroups only )|||Thanks, Anith,
While these didn't directly apply, I've found that I may
be able to solve the problem using the following statement
run from Command Prompt:
lotctr.exe c:\<SQL Server Install>\Binn\sqlctr.ini
It does require a reboot of the server, and I won't be
able to do that until late tonight, so I'll know tonight
if that solves my problem. I do know that none of the SQL
performance counters are available in Performance Monitor
either.
Allen
>--Original Message--
>The system table master..sysperfinfo is a virtual one
which is dynamically
>maintained by SQL Server. So you cannot manually update
them as you wish.
>Also, it is possible that the SQL Server is started with
a -x switch which
>disables certain internal statistics. There are many
reasons why you do not
>see any performance monitor counters, some of which are
detailed below:
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;246328
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;127207
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;227662 (old)
>--
>- Anith
>( Please reply to newsgroups only )
>
>.
>