Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Measuring transaction throughput - which perfmon counter? Expand / Collapse
Author
Message
Posted Monday, July 1, 2013 8:30 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 4:05 AM
Points: 907, Visits: 1,903
Im using perfmon to measure transaction throughput on a server. The problem is I don't know which to measure.

Theres a Transactions\sec counter for each database. The database in question is showing 2500+ transactions\sec
There is a Transactions in the SQL Server\Transactions group.
Theres a Transactions counter in the SQLServer\General Statistics group. This counter is showing 20 Transactions.


As they all have different values, im not sure which one is correct purposes. can anyone advise a bit further on which is the most relevant metric?
Post #1469087
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse