sysperfinfo counters SQL-Server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: richard (rschiller_at_utanet.at)
Date: 06/25/04 

Date: 25 Jun 2004 03:41:21 -0700

Hi,

could somebody explain to me, how the counters in the SQL-Server
sysperfinfo table are build? I mean, if the documentation says e.g.
"trans/sec" - what time frame does it mean? Is is since the start of
the instance, is it in the last 10 min? I cannot find any description
about the monitoring methodology used, though it would be important to
know for proper interpratation of it.

Thank you

Richard