Monitoring is a continual process of a database administrator. This helps ensure quality and efficiency of a system. To assist dbas with this task Red Gate has created a product known as SQL Response. This tool allows DBAs to monitor multiple SQL Servers at the same time. The monitoring of the SQL Servers are provided through alerts. There are three types of alerts within SQL Response.
1.) Server alerts
2.) Job Alerts
3.) Process Alerts.
The alerts are color coded on the SQL Response interface to make it easier for the DBA to notice problems or alerts. Red symbolizes a high alert, yellow symbolizes a medium alert, and blue symbolizes low alerts. This also helps the DBA prioritize the alerts. The alerts are in turn stored in an Alert Repository. There are two methods for configuring the Alert repository. The first option is to configure the repository on a server other than the SQL Response client. The second option is to configure the repository on the same servers that the SQL Response client is installed. Alert information remains within the Alert Repository for six months.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment