Anyone knows how to see the lastActivity of each connection?
asked 16 Nov '15, 11:38
If by "last Activity" you mean what did each connection do, when did it do it, then the easy answer is to use
to get this information about connection connid
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.