Results 1 to 3 of 3

Thread: Select * from sysperfinfo returns 0 rows.

  1. 08-15-2003, 08:41 AM #1
    jbrajgor
    jbrajgor is offline Registered User
    Join Date
    Sep 2002
    Posts
    21

    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,
    Reply With Quote Reply With Quote
  2. 08-15-2003, 08:49 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    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.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 08-15-2003, 10:15 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Seems system didn't load sql related counts, follow instructions in kb article q196657 to reload them.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules