Documentation

Microsoft SQL Server monitoring

LPAR2RRD obtains data through SQL protocol.
LPAR2RRD requires a database user (typically "lpar2rrd") with the VIEW SERVER STATE permissions to collect monitoring data

Microsoft SQL Server monitoring schema

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

Buffers
Microsoft SQL Server monitoring Buffers

Sessions
Microsoft SQL Server monitoring Sessions

Capacity
Microsoft SQL Server monitoring Capacity

IO
Microsoft SQL Server monitoring IO

SQLquery
Microsoft SQL Server monitoring sqlquery