Description
Monitors MSSQL Database General Statistics like User connections and Blocked processes.
Prerequisites
The database you want to monitor should connect from the Gateway. Gateway Management profile should be added to the device. Database type credentials should be added against the device in the portal.
Metric Parameters
Parameter | Description |
---|---|
Frequency | Warning Threshold | If the metric value satisfies the condition defined along with Warning Threshold value, then a notification is sent to the user. |
Critical Threshold | If the metric value satisfies the condition defined along with Critical Threshold value, then a notification is sent to the user. |
Alert | The alert value can be set to either Yes or No. If it is Yes, then an alert message is sent to the user. |
Metrics
mssql.user.connections
Metric Details
Applicable for | CLOUD_PAAS_DB |
Description | The number of users connected to the system. |
Category | Application |
Collector Type | Gateway |
Monitor Name | Advanced Cloud MSSQL Database General Statistics Monitor |
Unit |
Possible Inputs
Metric | Input Value | Range of Values |
---|---|---|
Frequency | 5 | 1 – 1440 (mins) |
Filter | ||
Warning Operator | ||
Warning Threshold | ||
Warning Repeat Count | ||
Critical Operator | ||
Critical Threshold | ||
Critical Repeat Count | ||
Alert | No | Yes/No |
Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mssql.blocked.process
Metric Details
Applicable for | CLOUD_PAAS_DB |
Description | The number of currently blocked processes. |
Category | Application |
Collector Type | Gateway |
Monitor Name | Advanced Cloud MSSQL Database General Statistics Monitor |
Unit |
Possible Inputs
Metric | Input Value | Range of Values |
---|---|---|
Frequency | 5 | 1 – 1440 (mins) |
Filter | ||
Warning Operator | ||
Warning Threshold | ||
Warning Repeat Count | ||
Critical Operator | ||
Critical Threshold | ||
Critical Repeat Count | ||
Alert | No | Yes/No |
Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph