SYSPERFINFO

• Felipe Venancio

  Mr or Mrs. 500

  Points: 539

  More actions

  August 17, 2004 at 1:23 pm

  #83475

  My system table SYSPERFINFO is all the time empty, does someone knows why? or Does someone have the same problem?

   

  Regards,

  Felipe Venancio

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  August 17, 2004 at 1:32 pm

  #519430

  There was a bug where if you are running a perfmon trace and you re-start SQL server, perfmon counters will not be visible. The trace needs to be stopped when SQL Server is re-started.

   

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  August 17, 2004 at 1:51 pm

  #519437

  What is your SQL Server build number? can you post the result of select @@version?

  Your SQL Server has to be at least in build 780.

• Felipe Venancio

  Mr or Mrs. 500

  Points: 539

  More actions

  August 17, 2004 at 2:07 pm

  #519440

  Allen,

          the result was:

  Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

  Service Pack SP3a.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  August 17, 2004 at 2:11 pm

  #519442

  Contact Microsoft to get the fix. It should be free of charge.

  http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&Product=sql2k