Skip to main content

MSSQL Database

  • version: 3.6
  • Compatibility: v 7.5.3
  • Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Instance Name (Mandatory), Enable Time Monitoring, Metric Collection Interval (Mandatory)
  • Operation: monitors the MSSQL Database.
  • Plugin-Metrics:

MSSQL Database

MSSQL Database

MetricData Type
Active TransactionsNumeric
Data File Size (KB)Numeric
Log Flushed Bytes/secNumeric
Log File Size (KB)Numeric
Log File Used Size (KB)Numeric
Log Flush Waits/secNumeric
Log Utilization (%)Numeric
Replication Transactions/secNumeric
Transactions/secNumeric
Log Cache Reads/secNumeric
Log Cache Hit Ratio (%)Numeric
Bulk Copy Rows/secNumeric
Bulk Copy Throughput/secNumeric
Backup/Restore Throughput/secNumeric
DBCC Logical Scan Bytes/secNumeric
Shrink Data Movement Bytes/secNumeric
Log Flushes/secNumeric
Log Flush Wait Time (ms)Numeric
Log TruncationsNumeric
Log GrowthsNumeric
Log ShrinksNumeric
Database Size (KB)Numeric

Instance Columns:

Table

MSSQL Database Table

MSSQL Database Table

MetricData Type
TableString
Table RowsNumeric
Table Data Size (KB)Numeric
Table Index Size (KB)Numeric
Table Size (KB)Numeric