QUESTION POSED ON: 19 December 2005
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.
|
