August 17, 2009 at 3:48 pm
In the textdata column, I am getting this:
"-- network protocol: TCP/IP set quoted_identifier on set arithabort off set numeric_roundabort off set ansi_warnings on set ansi_padding on set ansi_nulls on set concat_null_yields_null on set cursor_close_on_commit off set implicit_transactions off set language us_english set dateformat mdy set datefirst 7 set transaction isolation level read committed "
What is it? There's no duration or reads for it?
August 18, 2009 at 12:12 pm
What you are seeing is the ExistingConnection event. This basically lists all existing connections along with the connection settings. This can be important because some of the settings change the behavior of queries. For example ANSI_NULLS:
When OFF you can use COLUMN = NULL
Since connections don't use CPU or read or write they don' show those columns.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:23 pm
Thanks. I think I understand now. There were just a lot of them. It seems like nothing to be concerned about.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply