Hi Guys, I'm fairly amateurish when it comes to SQL Server 2000 but I need to work out some ball-park figures on what the current metrics are for a few servers i.e. number of transactions per minute or some other gauge like that. I've done some research on SQL Profiler (way too much info captured?), TPC-C benchmarks, transaction log or Performance Monitor use, etc. but my eyes are starting to glaze over. Is there a simple way to get some metrics on current SQL2000 transaction load? Is it best to concentrate on what the transaction log has captured and analyse that somehow? There are multiple databases on the server so I kinda need a global metric for the entire server. Thanks in advance for any advice. Cheers
there is no such thing as generally applicable transaction metrics a tpc-C transactions consists of 1 call to SQL with 11 updates and inserts per transaction 1 call with 1 update, and 0.1 more complex updates your transaction could be completely different tpc-c is also completely optimized, chances are your application is not focus on understanding the characteristics of your app and optimizing your important queries
I would never take up TPC benchmarks as it tends to be different as compared to individual environment. In order to achieve the stats I would take help of PROFILER & SYSMON (PERFMON) during busy & easy periods on SQL server. http://www.sql-server-performance.com/sql_server_performance_audit5.asp http://support.microsoft.com/kb/319942/EN-US/ ..the above articles should help you upto some extent. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.
Excellent, thanks satya, I'll take a look at the articles and let you know if I've any issues. Cheers.
