May 24, 2006 at 2:04 pm
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?
May 25, 2006 at 6:44 am
http://www.microsoft.com/technet/scriptcenter/sgwho.mspx
This is a link to the script center at MS. It has links to script blogs, etc. You might find your answer there.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply