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:

Metric	Data Type
Connected Sessions	Numeric
Active Sessions	Numeric
Idle Sessions	Numeric
Blocked Sessions	Numeric

Instance Columns:

Session Id

Metric	Data Type
Session Id	String
Session Used Memory (KB)	Numeric
Session CPU Time (ms)	Numeric
Session Failed Logons	Numeric
Session Reads	Numeric
Session Writes	Numeric
Session Remote Host	String
Session Domain User	String
Session Domain	String
Session Program Name	String
Session Login Name	String
Session Login Time	String
Session Status	String
Session Duration (Seconds)	Numeric
Session Duration	String

Waiting Session Id

Metric	Data Type
Waiting Session Id	String
Waiting Session Remote Host	String
Waiting Session Domain User	String
Waiting Session Domain	String
Waiting Session Program Name	String
Waiting Session Login Name	String
Session Wait Duration (ms)	Numeric
Session Wait Type	String

Blocked Session Id

Metric	Data Type
Blocked Session Id	String
Blocking Session Id	String
Session Database	String
Session Resource Type	String
Session Resource Mode	String
Session Blocked Query	String
Session Blocking Query	String
Blocked Session Remote Host	String
Blocked Session Domain User	String
Blocked Session Domain	String
Blocked Session User	String
Blocking Session Domain User	String
Blocking Session Domain	String
Blocking Session User	String
Blocked Session Program Name	String