DWTCIT
asked on
how to increase sql 2005 server database number of connections?
Hi,
We have a web application which needs big number of database connections. whenever we are trying to publish sites it is failing and when we invistigated it we found that SQL server policy is accepting 300 database connections as our vendor said & we need to increase the number of database connections.
I have opened the Managment Studio, right click on the server, properties the I moved to connections tab and I found the maximum number of concurrent connections is "0" which supposed to mean unlimited number of connections
I contiued my invistigation and I found that due to a security feature of Windows Server 2003, Windows may drop connections if the requests arrive faster than SQL Server can service them in order to avoid server SYN flood. This security feature implements a finite queue for incoming TCP connection requests which results in the following error:
ProviderNum: 7, Error: 10054, ErrorMessage: "TCP Provider: An existing connection was forcibly closed by the remote host ...
What I need to know how I can increase the number of database connections and what are the side effects (if there any?)
Please help me it is an urgent issue
We have a web application which needs big number of database connections. whenever we are trying to publish sites it is failing and when we invistigated it we found that SQL server policy is accepting 300 database connections as our vendor said & we need to increase the number of database connections.
I have opened the Managment Studio, right click on the server, properties the I moved to connections tab and I found the maximum number of concurrent connections is "0" which supposed to mean unlimited number of connections
I contiued my invistigation and I found that due to a security feature of Windows Server 2003, Windows may drop connections if the requests arrive faster than SQL Server can service them in order to avoid server SYN flood. This security feature implements a finite queue for incoming TCP connection requests which results in the following error:
ProviderNum: 7, Error: 10054, ErrorMessage: "TCP Provider: An existing connection was forcibly closed by the remote host ...
What I need to know how I can increase the number of database connections and what are the side effects (if there any?)
Please help me it is an urgent issue
ASKER
That means if I keep it 0 will it give me 32,767 connections? or it is better to set it as "32,767"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And change it to either 600 or 1000 and check it out..
Another workaround would be to fine tune your existing queries, so that they execute faster releasing the connections to waiting users..