Skip to main content

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

MSSQL Metrics

MetricData Type
Lazy Writes/secNumeric
Free List Stalls/secNumeric
Active TransactionsNumeric
Transactions/secNumeric
Log GrowthsNumeric
Buffer Cache Hit Ratio (%)Numeric
Cache Object CountsNumeric
Used Cache ObjectsNumeric
Cache PagesNumeric
Cache Hit Ratio (%)Numeric
Lock Requests/secNumeric
Lock Waits/secNumeric
Latch Waits/secNumeric
Lock Timeouts/secNumeric
Average Latch Wait Time (ms)Numeric
Average Lock Wait Time (ms)Numeric
Deadlocks/secNumeric
SQL Compilations/secNumeric
SQL Recompilations/secNumeric
Table Lock Escalations/secNumeric
Full Scans/secNumeric
Batch Requests/secNumeric
Probe Scans/secNumeric
Range Scans/secNumeric
Auto Param Attempts/secNumeric
Workfile Creates/secNumeric
Worktable Creates/secNumeric
Page Splits/secNumeric
Failed Auto Params/secNumeric
Active ConnectionsNumeric
Blocked ProcessesNumeric
Logins/secNumeric
Logouts/secNumeric
Page Reads/secNumeric
Page Writes/secNumeric
Page Lookups/secNumeric
Checkpoint Pages/secNumeric
Page Life Expectancy (sec)Numeric
Database PagesNumeric
Stolen PagesNumeric
Free PagesNumeric
Total PagesNumeric
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 GrantsNumeric
Granted Workspace Memory (KB)Numeric
Memory Outstanding GrantsNumeric
System Uptime (Seconds)Numeric
UptimeString
VersionString
Connection Time (ms)Numeric