January 14, 2008 at 9:14 am
I have the opportunity to have our Server guys set up HP openview to monitor our SQL Server Instance and send me alerts when there are problems. I would definitely like to know what the disk space trending is so I know if I have a log out of control or backups not being deleted.. and of course things like CPU Utilization, SQL Server services not running, can't ping server etc.. etc.. but on the SQL Server side - can anyone make suggestions on what kind of things I should be monitoring on the Server?
January 14, 2008 at 2:17 pm
Generally speaking,
CPU usage
Free disk space
Failed jobs
...
You may turn on other counters when such an isssue comes up.
January 14, 2008 at 2:44 pm
I grab reads/sec, transactions/sec, and some disk activity as a baseline in addition to above. Nice to have when someone says "it's slow"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply