July 7, 2011 at 12:35 am
i am using SQL Server 2008 R2 (10.50.1600)
I am not sure why it happens but i found that whenever i connect to database server via SSMS, it created multiple connections to the server. i have just connected to the server, opened a new query window and ran sp_who2.
what i found is multiple connections against my username from my machine!!!
how can this be possible?? the only connection i should have be of query window or i can say another one for the object explorer but why 4.
do you guys have any insight on this,weather its normal or something is fishy.
for your reference i am attaching activity monitor snapshot
July 8, 2011 at 4:20 am
I wouldn't have an answer, however I can give you some pointers to check what all the Connections are doing.
Use the SQL DMV
or use DBCC INPUTBUFFER(@SPID)
Check what is the Last SQL ran to make further investogation.
July 11, 2011 at 8:37 am
there will usually be three connections, one for the object explorer (this is the program WITHOUT query at the end) and then the query window connection itself and I also believe that the properties of the query window has its own SPID so this is normal yes
the running connection in the capture will be activity monitor (tempdb) which will make it 4
July 11, 2011 at 5:22 pm
thanks for the explanation 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply