July 24, 2002 at 12:24 pm
I am setting up a production server and I was look for a good list of generic Alerts I should set up on the server. Do you have any suggestions?
July 24, 2002 at 1:32 pm
Space (log and data) are always good. You might want deadlocks. Not sure I'd set many more without intending to watch for a specific problem.
Steve Jones
July 24, 2002 at 3:46 pm
Do you set the space alerts for the system db's, application db's, or both? Also, would you recommend alerts on cpu utilization and memory utilization?
Thanks for the help.
July 24, 2002 at 3:50 pm
Both and no alerts on mem or cpu.
The cpu can easily peg for moments on a query and I don't want to know it. It usually resolves itself. If it continues, I'd run perfmon or profiler and figure out why. Same for memory.
Steve Jones
January 24, 2003 at 9:02 am
What is the best way of setting up alerts for space used in the data file? Log space used is obviously easy as percent used is there aa a counter! I would like an alert that triggers when the datafile percent used is >= 60%
January 24, 2003 at 12:06 pm
I would say it depends on your configuration.
Having 40% freespace left in your log could be few as it coud be far enough.
40% of 18 GB is much less then 40% of 1,8TB.
You have also to know how dynamically is your database/ log/tempdb is growing.
So you can define your own values sometimes 40% freespace left, sometimes 1% freespace left.
But I would definitly monitor your DB, LOG and the tempdb sizes.
The other system databases are quite statical, they wouldn't grow dramatically
Bye
Gabor
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply