ManageEngine® SQLDBManager Plus
Creating Threshold Profile
Thresholds let you define the status of an attribute based on specific conditions. For example, you can define a threshold to show the status of the SQL Server as critical, if the response time exceeds 100 seconds. Likewise, you can define a threshold to show the status as clear, if the SQL Server response time drops below 100 seconds.
To define a threshold, follow the steps given below:
Click New Threshold. This opens the Create New Threshold Profile screen
Create New Threshold Profile for Numeric Values or for String Values
Specify the Threshold Name.
Specify the conditions for the different severity of the alarms. You can also specify a message that has to be appended to the alarm. By default, you can configure Critical severity, By clicking on advanced, you can configure Warning and Clear severity.
Specify the number of polls that can be scheduled before reporting an error. By default, it takes the value from Global Settings. Refer Configuring Consecutive Polls for setting configurations for individual monitors.
Click Create Threshold Profile to add the threshold after defining all the conditions.
Choose the View Thresholdoption available in the top menu to view the threshold. The Threshold Profile screen
lists all the default thresholds and newly created thresholds.
Note: You can also edit the threshold created using the edit icon.
You can also associate thresholds and actions directly through Global Alarm Configuration instead of the individual SQL Server screen.
Refer to Associating Threshold and Action with Attributes for more details.
Configuring and Viewing Alarms
Associating Threshold and Action with Attributes