SQL Server Performance

WMI with SQL 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by ttroisi, May 24, 2006.

  1. ttroisi New Member

    Querying the Win32_PerfRawData_MSSQLServer_SQLServerGeneralStatistics WMI class on a SQL 2005 server returns a ridiculously high number for UserConnections - like 34282428956712. This works fine on SQL 2000.

    Does anybody know a formula for converting this counter to a meaningful value on SQL2k5?
  2. satya Moderator

    Not much information available on WMI with SQL 2005 recently, probably you would get more if you can in WMI related newsgroups.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page