April 13, 2010 at 9:13 am
Hi Chaps.
Just looking into the connections on one of my servers, I noticed I had around 20 connections to it. All from 1 host. I had one ManStud window open + object browser + traces.
Closed traces and Object browser. Now 18.
Dbcc inputbuffer of the others showed a lot of
(@_msparam_0 nvarchar(4000),@_msparam_1 nvarchar(4000),@_msparam_2 nvarchar(4000))
SELECT clmns.name AS [Name] FROM sys.tables AS tbl INNER JOIN sys.all_columns AS clmns ON clmns.object_id=tbl.object_id WHERE (CAST(clmns.is_sparse AS bit)=@_msparam_0)and((tbl.name=@_msparam_1 and SCHEMA_NAME(tbl.schema_id)=@_msparam_2)) ORDER BY clmns.column_id ASC
These went away after I logged off the server and came back on.
Any idea what it is that is hogging these connections and not freeing them up?
Cheers
Rich
April 13, 2010 at 12:19 pm
How many traces?
Also did you do a sp_who2?
April 15, 2010 at 4:12 am
Traces? A couple, but thats not it.
Sp_who2 - yeah, not a lot of help.
Our current thinking is it might be something to do with code completion.
April 15, 2010 at 8:25 am
Seems logical.
Another thought, do you have a lot of databases expanded out in Object explorer?
April 16, 2010 at 4:49 am
Did, but shut down the browser. Not sure if I disconnected it all first though. Seems all a bit odd to me.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply