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?