on 2015 Nov 16 11:38 AM
Anyone knows how to see the lastActivity of each connection?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Exactly how is connection_extended_property called without the second argument but with the third argument?
AFAIK in this context connection_property is the function of choice.
One doesn't try to omit a parameter ;-). I corrected my answer to use connection_property()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.