Q

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

Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close