Description
These monitors show how SQL Server uses memory and physical I/O to store, read and write data pages.
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.database.page.reads
Metric Details
Applicable for | Device |
Description | Number of physical database page reads issued. |
Category | Application |
Collector Type | Gateway |
Monitor Name | G2 MSSQL Database Buffer Monitor |
Unit | psec |
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.database.page.writes
Metric Details
Applicable for | Device |
Description | Number of physical database page writes issued. |
Category | Application |
Collector Type | Gateway |
Monitor Name | G2 MSSQL Database Buffer 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
mssql.buffer.lazy.writes
Metric Details
Applicable for | Device |
Description | Number of buffers written by buffer manager's lazy writer. |
Category | Application |
Collector Type | Gateway |
Monitor Name | G2 MSSQL Database Buffer 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
mssql.checkpoint.pages
Metric Details
Applicable for | Device |
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 | G2 MSSQL Database Buffer Monitor |
Unit | psec |
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