on 2015 Nov 16 11:38 AM
Anyone knows how to see the lastActivity of each connection?
Request clarification before answering.
If by "last Activity" you mean what did each connection do, when did it do it, then the easy answer is to use
select connection_property( 'LastReqTime', connid ),
connection_property( 'LastStatement', connid )
to get this information about connection connid
See this documentation page for a full list of information about each connection that can be obtained by using connection_property() or connection_extended_property()
You can also get the connection activity information by using the sa_conn_activity() procedure.
FWIW: You can get the full list of properties for a connection (or all connections) by using the sa_conn_properties() procedure.
HTH
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
30 | |
9 | |
9 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.