Tuesday, 24 September 2013

How to find detail about each connection currently established on Sql Server

Please refer the below query :

Select session_id,connect_time,num_reads,num_writes,
Last_read,last_write,most_recent_sql_handle
From sys.dm_exec_connections;
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)