Select * from sysperfinfo returns 0 rows.

Hi,

I have DB monitoring jobs which use Sysperfinfo to monitor some of the counters. On One SQL 2K Server since few days the select on sysperfinfo returns 0.

Do you think I need to start any service from the OS side to enable this?

Your input is highly apppreciated.

Thanks,:confused:

do you have more than 99 databases on that box? and what OS you are using?

From BOL:

sysperfinfo
Contains a Microsoft® SQL Server™ representation of the internal performance counters that can be displayed through the Windows NT Performance Monitor

Note The Windows NT Performance Monitor is available only when using Microsoft Windows NT® 4.0 as the operating system.

Performance condition alerts are only available for the first 99 databases. Any databases created after the first 99 databases will not be included in the sysperfinfo system table, and using the sp_add_alert procedure will return an error.

Seems system didn't load sql related counts, follow instructions in kb article q196657 to reload them.