Check SQL Server 2000 Load

[perrymans]

I don't want to do a load test, I want to see what the current usage load is and determine if it is a burden on the system (which I do not believe that it is).

What is the easiest to run/ view to achieve a load level, and perhaps even how it compares to what the system could/ should be able to do?

Thanks. Sean.

 

[mrdenny]

Use Performance Monitor to check the CPUs, Memory usage, hit cache ratio, disk queues, etc.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com