Description
Monitors MSSQL Last elapsed time, Buffer cache hit ratio, Procedure Cache Hit ratio, MSSQL PageLifeExpectancy.
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
msql.last.elapsed.time
Metric Details
| Applicable for | Device |
| Description | Elapsed time, reported in microseconds (but only accurate to milliseconds), for the most recently completed execution of this plan. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MSSQL Database Miscellaneous Monitor |
| Unit | microsec |
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.buffer.cache.hit.ratio
Metric Details
| Applicable for | Device |
| Description | Percentage of pages that were found in the buffer pool without having to incur a read from disk. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MSSQL Database Miscellaneous 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.procedure.cache.hit.ratio
Metric Details
| Applicable for | Device |
| Description | Procedure Cache Hit ratio (calculated from server start-up) |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MSSQL Database Miscellaneous Monitor |
| Unit | NULL |
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.page.life.expectancy
Metric Details
| Applicable for | Device |
| Description | Number of seconds a page will stay in the buffer pool without references. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MSSQL Database Miscellaneous Monitor |
| Unit | s |
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