MS SQL Server Monitoring
LPAR2RRD requires a database user (typically "lpar2rrd") with the VIEW SERVER STATE permissions to collect monitoring data
 |
Collected Metrics
| Subsystem | Metric | SQL Server instance | Database |
|---|---|---|---|
| Health status | Health status | yes | |
| DB TOP | IOPS | yes | |
| DATA in MB | yes | ||
| User Connections | yes | ||
| Configuration | Main | yes | |
| Memory | Memory | yes | |
| Buffers | Buffer | yes | |
| Readahead | yes | ||
| Page R/W | yes | ||
| Pages | yes | ||
| Sessions | Sessions | yes | |
| Latches | IO | yes | |
| Buffer | yes | ||
| Non Buffer | yes | ||
| Wait events | Events | yes | |
| Capacity | Size | yes | |
| Relations | yes | ||
| Filegroups | yes | ||
| IO | Total | yes | |
| Read/Write | yes | ||
| Data | Total | yes | |
| Read/Write | yes | ||
| Latency | Total | yes | |
| Read/Write | yes | ||
| Locks | Locks | yes | |
| Deadlocks | yes | ||
| SQL Querty | Transactions | yes | |
| Cursors | yes | ||
| Ratio | Cache hit | yes | |
| Buffer Cache hit | yes | ||
| Log Cache hit | yes |
You can see implementation on Free Demo
Examples
Sessions
Capacity
IO
SQLquery
