Description
It monitors MSSQL Last elapsed time, Buffer cache hit ratio, Procedure Cache Hit ratio, MSSQL PageLifeExpectancy.
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
msql.last.elapsed.time
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| 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 | Advanced Cloud 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 | CLOUD_PAAS_DB |
| 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 | Advanced Cloud 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 | CLOUD_PAAS_DB |
| Description | Procedure Cache Hit ratio (calculated from server start-up) |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud 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 | CLOUD_PAAS_DB |
| Description | Number of seconds a page will stay in the buffer pool without references. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud 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