Skip to main content

MSSQL Session

  • version: 3.8
  • Compatibility: v 7.5.3
  • Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Instance Name (Mandatory), Timeout (Mandatory), Metric Collection Interval (Mandatory)
  • Operation: monitors the MSSQL Session.
  • Plugin-Metrics:
MetricData Type
Connected SessionsNumeric
Active SessionsNumeric
Idle SessionsNumeric
Blocked SessionsNumeric

Instance Columns:

Session Id

MetricData Type
Session IdString
Session Used Memory (KB)Numeric
Session CPU Time (ms)Numeric
Session Failed LogonsNumeric
Session ReadsNumeric
Session WritesNumeric
Session Remote HostString
Session Domain UserString
Session DomainString
Session Program NameString
Session Login NameString
Session Login TimeString
Session StatusString
Session Duration (Seconds)Numeric
Session DurationString

Waiting Session Id

MetricData Type
Waiting Session IdString
Waiting Session Remote HostString
Waiting Session Domain UserString
Waiting Session DomainString
Waiting Session Program NameString
Waiting Session Login NameString
Session Wait Duration (ms)Numeric
Session Wait TypeString

Blocked Session Id

MetricData Type
Blocked Session IdString
Blocking Session IdString
Session DatabaseString
Session Resource TypeString
Session Resource ModeString
Session Blocked QueryString
Session Blocking QueryString
Blocked Session Remote HostString
Blocked Session Domain UserString
Blocked Session DomainString
Blocked Session UserString
Blocking Session Domain UserString
Blocking Session DomainString
Blocking Session UserString
Blocked Session Program NameString