Monitor connection pool

Discussion in 'Databases' started by GBiggs, Jun 30, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. GBiggs

    GBiggs

    I believe I am closing all connections immediately after the query executes. However I am getting max pool size errors on a new web application we are building out. I would like to monitor connection pooling behavior.

    I do _not_ want to increase the maximum pool size, I do _not_ want to increase the time out setting and I do _not_ want to turn off pooling. I jut want to track down the problem and fix it.

    Is there something like EXEC SP_WHO that I can run against the database as I test so I can monitor exactly how many connections are open? It this point it should never be more than one.

    Thanks
     
    GBiggs, Jun 30, 2010
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    you cannot run sp_who against the server.

    If you are getting the connection pool error, your application opened more than 100 connections to the database.

    With this many connections, you should be able to easily identify the problem in your development environment.
     
    Bruce, Jul 1, 2010
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page