Tuesday, March 20, 2012

Connections Limit?

Hi,

I have an application with a DAL that has an interface with SQL Server.
The application has 400 users that open the web forms.
My question is:
Is there a limit of the parallel connections that can be opened? Or the IIS is managing all the access to the DB? Should I worry about the performance Or it's normal behaviour for ASP.NET applications?

Thanks::The application has 400 users that open the web forms.

No, it does not. It has 25 users concurrently per processor, maximum. Unless you play around with the settings, this is the number of workther threads ASP.NET utilizes.

::Or the IIS is managing all the access to the DB?

It is, but you musth avea programming error, because the number should never go higher than 25 per processor.

You are not, by chance, not closing the connections?sqlsql

No comments:

Post a Comment