SQL Counter: Part 11 (Transactions/sec) January 13th, 2008

Vinod Kumar

SQL Server Database Object -> Transactions/Sec
This counter measures the number of transactions started per second. Transactions are the basis of everything in SQL Server, and most queries are implicit transactions. This measurement is extremely handy for determining if the load has substantially increased over time. This also gives you an indicator to how the workload is on your system.

Share this article

Tags: , ,

This entry was posted on Sunday, January 13th, 2008 at 13:13 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply



 

Email
Print