ManageEngine® SQLDBManager Plus
Working with SQL DB Manager
The following are the steps involved in monitoring:
Add SQL Server : Add SQL server in the network and start collecting data (performance metrics, availability etc) for the same.
Create threshold profile : Create thresholds to identify the status of a specific attribute.
Create actions : Specify what action needs to be taken in the event of an alarm.
Associate threshold and action with the attributes : Associate the thresholds and action to generate alarms and perform action based on the threshold definition.
Configuring dependencies : Dependencies specify the rule based on which the severity of health and availability is determined. For example, Health of a DB Server may depend on the overall response time of the server etc. By configuring dependencies, you can determine the attribute, based on which the severity of health changes.
Please go through Configuring Alarms for detailed information on the above.
Prerequisites for SQL DB Manager
Working with SQL Groups