Description
MSSQL Database Resource pool Stats Template describes Resource pool used memory, Resource pool CPU usage and Resource pool disk read IO.
Prerequisites
MSSQL must be installed on the target machine.
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.resource.pool.used.memory
Metric Details
Applicable for | Device |
Description | The amount of memory used, in kilobytes (KB), for the resource pool. |
Category | Application |
Collector Type | Gateway |
Monitor Name | G2 MSSQL Database Resource pool Stats Monitor |
Unit | KB |
Possible Inputs
Metric | Input Value | Range of Values |
---|---|---|
Frequency | 2 | 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.resource.pool.disk.read.io
Metric Details
Applicable for | Device |
Description | Number of read operations from the disk in the last second. |
Category | Application |
Collector Type | Gateway |
Monitor Name | G2 MSSQL Database Resource pool Stats Monitor |
Unit | rops |
Possible Inputs
Metric | Input Value | Range of Values |
---|---|---|
Frequency | 2 | 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.resource.pool.disk.write.io
Metric Details
Applicable for | Device |
Description | Number of bytes written to the disk in the last second. |
Category | Application |
Collector Type | Gateway |
Monitor Name | G2 MSSQL Database Resource pool Stats Monitor |
Unit | wps |
Possible Inputs
Metric | Input Value | Range of Values |
---|---|---|
Frequency | 2 | 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