x

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.

more ▼

asked Mar 01, 2011 at 01:59 PM in Default

avatar image

srivivek
535 41 42 47

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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

more ▼

answered Mar 01, 2011 at 02:02 PM

avatar image

Tim
40.4k 39 84 166

(comments are locked)
10|1200 characters needed characters left

`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.

more ▼

answered Mar 01, 2011 at 02:04 PM

avatar image

ThomasRushton ♦♦
39.7k 20 49 52

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

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

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x67

asked: Mar 01, 2011 at 01:59 PM

Seen: 1336 times

Last Updated: Mar 01, 2011 at 01:59 PM

Copyright 2016 Redgate Software. Privacy Policy