January 22, 2008 at 1:21 pm
On our prodn server if i do sp_who i see lots fo connection to teh same database say 'DatabaseA' but if i cehck for active connection i see only 3 connections. does that mean only 3 connections are currently made to the database or there are n no fo connection which arent closed. Will these too many connection degrade performance in anyway..
January 22, 2008 at 1:27 pm
Hello Ishaan,
There might be 'n' number of connections to the same database but there might be some which are not doing anything. You can check on a development machine by running the same query after you open 10 Query Analyzer windows and in some of them you run a basic select query. Now you see the results and look at the status column. This shows that there are 10 connections but some of them are expecting something like a command or in sleeping condition.
Hope this helps you.
Thanks
Lucky
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply