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.

asked Mar 01 '11 at 01:59 PM in Default

srivivek
519 ● 30 ● 39 ● 42

(comments are locked)

2 answers:

A good place to start would be performance monitors looking at CPU, DISK, and Memory.

answered Mar 01 '11 at 02:02 PM

Tim
31.5k ● 20 ● 31 ● 116

(comments are locked)

sp_monitor and select * from ::fn_virtualfilestats 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 for more info.

answered Mar 01 '11 at 02:04 PM

ThomasRushton ♦
29.4k ● 6 ● 9 ● 36

(comments are locked)

Your answer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

performance-tuning x44

asked: Mar 01 '11 at 01:59 PM

Seen: 651 times

Last Updated: Mar 01 '11 at 01:59 PM

how to see DataBase load / performance during job runs in sql server 2000

Follow this question

Related Questions