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)
 Sysperfinfo is not populated

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-03-19 : 07:39:08
Rachid writes "Hi,

In one of my servers, sysperfinfo table is empty. As a result, I cannot collect performance statistics for this server. Has any one seen this and how to fix it??? Thanks a lot.

Rachid"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-03-19 : 13:43:57
That table contains static data only, so just copy the data from another server (you'll have to allow updates to the system catalog to do this).

I am not sure why your table is empty, so you might want to do some research on this on MS' knowledge base (support.microsoft.com).

Tara
Go to Top of Page
   

- Advertisement -