Post reply

sp_reset_connections - DORMANT connections

  • October 21, 2010 at 2:28 am

    #228127

    Hi all,

    sp_reset_connection is used to reset(for re-using) a connection from the connection pool.

    I would like to know whether any options available inside the SQL Server to control the number of connections, so DBAs can control it.

    There are huge number of threads in DORMANT status present in the servers with SP sp_reset_connection.

    Thanks in Advance

    John

  • October 21, 2010 at 5:25 am

    #1240192

    Remember that connections are different from threads. One connection can spawn many threads.

    Which is it you're trying to control? Connections or threads?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply