Post reply

Database Connections

  • January 22, 2008 at 1:21 pm

    #154079

    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

    #770638

    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