Meditation on sys.dm_exec_connections
I saw an email thread recently regarding sys.dm_exec_connections and I thought I would spread the word if you aren't already using this DMV in your troubleshooting toolbox. This DMV can answer several different questions. For example:
Q. Is a connection using SSL encryption?
A. Use the encrypt_option column.
Q. Is a connection using Kerberos, NTLM, or SQL authentication?
A. Use the auth_scheme column.
Q. How long has the session been connected to SQL Server?
A. See connect_time.
Q. Is this connection doing anything?
A. See num_reads, num_writes, last_read, and last_write.
Q. Where is this client coming from, and how is it connecting?
A. See client_net_address, client_tcp_port, net_transport, and protocol_type.
Comments
Anonymous
June 01, 2009
PingBack from http://indoorgrillsrecipes.info/story.php?id=3313Anonymous
February 06, 2011
I like to find something on the topic as I visit frequently... log on to http://earlyglow.blogspot.comAnonymous
April 01, 2011
It is actually the practice to relief your mind by pushing out all the thoughts and thinking and focusing completely on a point, whatever it can be. But it’s just the concept yet.......... http://www.spiritualeyes.info/