asked
how to see DataBase load / performance during job runs in sql server 2000
how to check the Data Base load / performance during job runs in sql server 2000(from sql DBA end). can anyone please suggest what are the steps to be followed.
A good place to start would be performance monitors looking at CPU, DISK, and Memory.
[`sp_monitor`][1] and [`select * from ::fn_virtualfilestats`][2] are your friends for monitoring stats within SQL Server. See also the various performance monitors within the standard windows performance monitoring tool. See some of [these articles][3] for more info. [1]:
http://msdn.microsoft.com/en-us/library/aa238856(v=sql.80).aspx [2]:
http://msdn.microsoft.com/en-us/library/aa258871(v=sql.80).aspx [3]:
http://www.google.co.uk/search?q=sql+server+performance+monitor
