Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
The 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?
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.
