Monitoring Connection Pools from ADO.net to SQL Server

  • Folks

    As we all know, you can set up connection pooling from a .Net application and use a Max and Min setting to govern the number of connections in the pool.

    My question: Is there a Performance Monitor or SQL Profiler trace or some other counter that can be used to see:

    1. How many Connections are active in the Pool

    2. When the Max connection for this pool ( or any pool) has been exceeded

    (This assumes that the Application Name has been set on the connection string)

    Thanks in advance

    regards

    GregJF

Viewing post 1 (of 1 total)

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