March 9, 2008 at 3:40 pm
Good Day Everyone,
I was wondering what's the best means of identifying the number of transactions processed in SQL 2005 on a monthly basis? All suggestions would be greatly appreciated
Frederick
March 9, 2008 at 4:37 pm
use performance monitor. there is a counter for transactions/sec. its under the SQLServer:Databases objects
March 9, 2008 at 7:55 pm
Good to know this counter. Just found an earlier post from Steve mentioned about it.
Performance Monitoring - Basic Counters
http://qa.sqlservercentral.com/articles/Administering/performancemonitoringbasiccounters/1348/
March 10, 2008 at 7:19 am
SQL Server Databases object Transaction/sec doesn't measure activity unless it's inside a transaction. SQL Server General Statistics Batch Requests/sec measures all batches you send to the server even if they don't participate in a transaction.
Choosing the Right Performance Monitor Counters SQLmag.com
March 10, 2008 at 7:24 am
Robert.concepcion (3/10/2008)
SQL Server Databases object Transaction/sec doesn't measure activity unless it's inside a transaction. SQL Server General Statistics Batch Requests/sec measures all batches you send to the server even if they don't participate in a transaction.Choosing the Right Performance Monitor Counters SQLmag.com
Very true and a good point. However i believe most people use it as a baseline performace counter and use this to compare current readings to see if the server load has increased/decreased. As long as you are monitoring the same counter on both the baseline tests and ongoing tests then you should get a good idea of how busy your server is.
March 10, 2008 at 7:28 am
Correct, batches can be a better measurement since most people don't send multiple statements in a batch.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply