Too many TCP/IP socket connections

Are you doing anything custom in your Kentico that may be causing this?

What Level of WebApp/SQL Server in azure are you using (B1, B2, S1, S2, P1, P2, etc). Kentico may need to be on a higher plan in order to run, i think minimum is S1 for the SQL server.

Hi

In my code I'm using the methods SelectSingleNodeand SelectSingleNodes from the class TreeProvider.

In my profiler, these methods doesn't run more than nessecary.

My WebApp is on level S2.

My SQL Server is also on level S2.

Kind regards

Kenny

This could be caused from a number of things like:

• multiple webparts on the same page calling the same data unnecessarily (use a single webpart or datasource)
• several API calls running at the same time
• your website running in a webfarm sharing the DTU's between the instances and running out of DTU's because of the above 2 items.
• scheduled tasks running in the background which don't need to or run too often (check the scheduled tasks and turn off ones which aren't needed)

What I'd do temporarily is change your Azure SQL plan to scale up to an S3 and see if anything changes. I'm guessing it will, then you'll need to do some research, aside from finding out which queries are running, into how your site is setup and what calls are being made from the Pages app.

Thanks Brenden

I'll check with the change of the Azure SQL plan.

Kind regards

Kenny