Monitor SQL Server -- possible?

[samjones3]

Greetings!

I am looking to monitor SQL Server. For example:

-- # of queries / second (or per min)
-- query run time (peak, avg)
-- RAM used
-- CPU used by SQL

And a few others....

Doable with cacti?

Thanks!!!

[mcutting]

If you can script it, Cacti can graph it. Take a look at the available WMI classes for SQL2000

[BSOD2600]

Also, search the script forum -- this has been asked and addressed.