Description
These monitors show how SQL Server uses memory and physical I/O to store, read and write data pages.
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.database.page.reads
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Number of physical database page reads issued. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MSSQL Database Buffer Monitor |
| Unit | psec |
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.database.page.writes
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Number of physical database page writes issued. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MSSQL Database Buffer Monitor |
| Unit | wps |
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.lazy.writes
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Number of buffers written by buffer manager's lazy writer. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MSSQL Database Buffer Monitor |
| Unit | wps |
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.checkpoint.pages
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Indicates the number of pages flushed to disk per second by a checkpoint or other operation that require all dirty pages to be flushed. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud MSSQL Database Buffer Monitor |
| Unit | psec |
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