Thursday 16 June 2011

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;

No comments:

Post a Comment