Hi Steve,
Do you know how to measure the max of a given server - (instead of finding out the hard way)? So that the TPS is less relative and more interpretive?
I just measured various databases for a test server I set up and they range between TPS of 1 million and zero. Oddly msdb has 1,160,005 which seems incredibly large. I am trying to figure out what to make of these numbers. Thank you!
Edited:
I believe I found my own answer: The entire script is here: http://stackoverflow.com/questions/5019593/sql-server-2008-transaction-per-second-for-specific-database