Description
Monitors Total server memory, Memory Grants Pending, Database cache memory, Connection Memory, Lock Memory, Free Memory, SQL Cache Memory, Optimizer Memory.
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.total.server.memory
Metric Details
| Applicable for | Device |
| Description | Total amount of dynamic memory the server is currently consuming |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MSSQL Database Memory Manager 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.memory.grants.pending
Metric Details
| Applicable for | Device |
| Description | Current number of processes waiting for a workspace memory grant |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MSSQL Database Memory Manager Monitor |
| Unit | NULL |
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.cache.memory
Metric Details
| Applicable for | Device |
| Description | Amount of memory the server is currently using for the database cache. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MSSQL Database Memory Manager 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.connection.memory
Metric Details
| Applicable for | Device |
| Description | Total amount of dynamic memory the server is using for maintaining connections. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MSSQL Database Memory Manager 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.lock.memory
Metric Details
| Applicable for | Device |
| Description | Total amount of dynamic memory the server is using for locks |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MSSQL Database Memory Manager 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.free.memory
Metric Details
| Applicable for | Device |
| Description | Amount of memory the server is currently not using. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MSSQL Database Memory Manager 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.sql.cache.memory
Metric Details
| Applicable for | Device |
| Description | Total amount of dynamic memory the server is using for the dynamic SQL cache |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MSSQL Database Memory Manager 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.optimizer.memory
Metric Details
| Applicable for | Device |
| Description | Total amount of dynamic memory the server is using for query optimization |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MSSQL Database Memory Manager 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