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 snapshot from SQL-2000?
Thanks in advance