January 28, 2011 at 4:05 am
Can anyone recommend a good set of Alerts (with threshold levels where appropriate) to set up to pre-empt the usual types of performance issues experienced on an instance? (i.e. caused by users running long/resource consuming queries).
Am new at monitoring performance levels so please excuse my lack of knowledge in this area, 🙂
Am very keen to see what other Alerts DBAs are using to monitor their instances?
Cheers
January 28, 2011 at 6:54 am
The general list I've looked at are the CPU%, memory pages/sec, page life expectenency, buffer cache hit ratio, disk Qs, % disk time.
You don't care if someone runs resource intensive queries, unless they affect other users. So you want to establish a baseline and note what you expect, so that when things are high, you can track down the issue.
January 28, 2011 at 11:09 pm
In addition to Steves list I also watch avg disk read/write sec
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply