Is there a maximum number of sockets that SQL can handle?
We're a software development company. Our product is a web-based natural language question answering system. On our servers, we implement a customer SQL database that stores thousands of question/answer pairs that are queried when users type questions on a web site. Our software is coded in Java and then makes a JDBC connection to the SQL database. However, the number of connections is obviously limited because our live customers database connections get maxed out and we don't know what the magic max-out number is. Also, we're having a TCP-to-SQL database connection (socket) max-out too, and we don't know where it's coming from either.
Is there a maximum number of sockets that SQL can handle? Are there limits on different types of concurrent socket connections to a SQL database?
If you have any answers to point us in the right direction to keep our customers live, we would appreciate it very much.
My first inclination is to look at the version of SQL Server. I believe the MSDN and/or Developer versions limit the number of connections to SQL Server. To determine the version execute SELECT @@VERSION in Query Analyzer. Here would be the sample output for the Developer edition:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
This was first published in December 2005