Can’t believe in 2011 I’m asking myself to think back over the years as to what I deem the most important database statistic. I’m obviously talking about performance, scalability, capacity, etc…statistic. I guess not even talking about a statistic as I’m talking about a measurement. I’m a firm believer it’s Transactions/Second. It’s such a meaningful metric that can be converted to minute, hour, day, etc…It can also be studied over time-series data. Oracle has long since made this metric easy to capture and to visualize.
SQL Server has the Transaction/Sec counter on the sys.dm_os_performance_counters DMV. It looks like you have to select the metric at Time X, then select it again at Time Y. Determine the number of seconds that transpired between X and Y. Then use the following formula (Metric X – Metric Y)/(Time X – Time Y) = Transactions/Sec.