patternsqlMinor
Is there a quickish, straighforward way to measure Transactions Per Second on SQL Server 2000?
Viewed 0 times
2000straighforwardpersqlwayquickishsecondservertransactionsmeasure
Problem
The
How can I measure transactions per second in SQL Server 2000?
sys.dm_os_performance_counters DMV introduced in SQL Server 2005 makes this task somewhat trivial. However, my Google-Fu has been blocked in finding a way to do this in SQL Server 2000. How can I measure transactions per second in SQL Server 2000?
Solution
I would suggest using the SQL Server Counters in the Windows PerfMon Utility.
This is for SQL 2005 but the instructions provide the gist of things for you.
This is for SQL 2005 but the instructions provide the gist of things for you.
Context
StackExchange Database Administrators Q#16779, answer score: 7
Revisions (0)
No revisions yet.