We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

View Complete Thread
  • Re: Monitoring open Sql connection in IIS

    Apr 19, 2021 02:23 AM|samwu|LINK

    Hi SAcod3,

    SAcod3

    This error can come from too many connection in SQL or IIS. Is there a way to monitor how many current connections open in IIS? The goal for me is see how many connection are open before I get the below error.

    You can use Performance Monitor to monitor pooled connections.

    https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/performance-counters

    SAcod3

    "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.

    The default value for Max Pool Size is 100. If your application is under very heavy load then this number may not be high enough. However, it's more likely that your application code is leaking connections by not disposing of them efficiently.

    Best regards,

    Sam

    IIS.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today. Learn more >