Our maximum number of concurrrent connections has been setted to 150. We have a Web site which is having about 200 users at the same time. Each ASP page is mostly connecting to SQL Server to get some data. Is there a way to determine an appropriate value for this parameter?
Right now, we are several messages in the Event Viewer:
Unable to connect. The maximum number of '150' configured user connections are already connected. System Administrator can configure to a higher value with sp_configure.