SQL Server Performance

Performance monitoring script for SQL-2000

Discussion in 'General DBA Questions' started by arka, Jun 24, 2010.

  1. arka New Member

    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
  2. arka New Member

    Thank you Steve.
  3. Luis Martin Moderator

    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.
  4. satya Moderator

    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....

Share This Page