Ask the Expert

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: