MSSQL¶
version: 3.7
Compatibility: v 7.5.3
Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Instance Name (Mandatory), Metric Collection Interval (Mandatory)
Operation: monitors the MSSQL.
Plugin-Metrics:
MSSQL Metrics¶
Metric |
Data Type |
Lazy Writes/sec |
Numeric |
Free List Stalls/sec |
Numeric |
Active Transactions |
Numeric |
Transactions/sec |
Numeric |
Log Growths |
Numeric |
Buffer Cache Hit Ratio (%) |
Numeric |
Cache Object Counts |
Numeric |
Used Cache Objects |
Numeric |
Cache Pages |
Numeric |
Cache Hit Ratio (%) |
Numeric |
Lock Requests/sec |
Numeric |
Lock Waits/sec |
Numeric |
Latch Waits/sec |
Numeric |
Lock Timeouts/sec |
Numeric |
Average Latch Wait Time (ms) |
Numeric |
Average Lock Wait Time (ms) |
Numeric |
Deadlocks/sec |
Numeric |
SQL Compilations/sec |
Numeric |
SQL Recompilations/sec |
Numeric |
Table Lock Escalations/sec |
Numeric |
Full Scans/sec |
Numeric |
Batch Requests/sec |
Numeric |
Probe Scans/sec |
Numeric |
Range Scans/sec |
Numeric |
Auto Param Attempts/sec |
Numeric |
Workfile Creates/sec |
Numeric |
Worktable Creates/sec |
Numeric |
Page Splits/sec |
Numeric |
Failed Auto Params/sec |
Numeric |
Active Connections |
Numeric |
Blocked Processes |
Numeric |
Logins/sec |
Numeric |
Logouts/sec |
Numeric |
Page Reads/sec |
Numeric |
Page Writes/sec |
Numeric |
Page Lookups/sec |
Numeric |
Checkpoint Pages/sec |
Numeric |
Page Life Expectancy (sec) |
Numeric |
Database Pages |
Numeric |
Stolen Pages |
Numeric |
Free Pages |
Numeric |
Total Pages |
Numeric |
Total Server Memory (KB) |
Numeric |
Target Server Memory (KB) |
Numeric |
SQL Cache Memory (KB) |
Numeric |
Lock Memory (KB) |
Numeric |
Optimizer Memory (KB) |
Numeric |
Connection Memory (KB) |
Numeric |
Memory Pending Grants |
Numeric |
Granted Workspace Memory (KB) |
Numeric |
Memory Outstanding Grants |
Numeric |
System Uptime (Seconds) |
Numeric |
Uptime |
String |
Version |
String |
Connection Time (ms) |
Numeric |