We are planning to set up performance monitoring tools/scripts to monitor daily activities of our SQL servers. For SQL-2005 and 2008 we will be using Performance Dashboard. I still need to find a simple way to get a snapshot of SQL-2000 perfomance (CPU, I/O read/write, memory, locks, etc). I know that I could use perfmon, but it will be more time consuming than just running a script. Does anybody have a stored procedure/script to extract performance data from SQL-2000? Thanks
You can user performance with counters running said,each 1 minutes or time you want. After a while you can review those counters with excel.
As you are using SQL 2000 there isn't much available from Enterprise manager, in this case you can take help of PERFMON as Luis suggested. See on this site: http://www.sql-server-performance.com/tips/sql_server_performance_monitor_coutners_p1.aspx http://www.sql-server-performance.com/articles/per/hardware_tuning_performance_p1.aspx http://technet.microsoft.com/en-us/library/cc966509.aspx KB #298475 HOW TO: Troubleshoot Application Performance Issues KB #243589 INF: Troubleshooting Slow-Running Queries on SQL Server KB #243588 HOW TO: Troubleshoot the Performance of Ad-Hoc Queries KB #224587 HOW TO: Troubleshoot Application Performance with SQL Server for your study & implemention....
