Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-29 : 10:06:26
|
| Chiranjeevi writes "Hi, SQL server 7.0 and windows ServicePack61)Can you please Tell at a time how many connections SQL serever can support(handle)?2)In case of linked server also . if one server using linked server , then at a time how many likned server connections it can handle.Thanks in advance.RegardsChiru" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-11-29 : 12:41:36
|
quote:
1)Can you please Tell at a time how many connections SQL serever can support(handle)?
This is a tricky question. According to SQL Server 7 Books Online (BOL), "SQL Server allows a maximum of 32,767 user connections.". However, the real number of connections that SQL Server can "handle" is dependent upon the code you write. I can write a syntactically correct SQL statement that will freak out SQL Server with just one connection. On the other hand, I can have thousands of people connecting and executing well-written SQL without too much trouble.The second tricky part of the answer is that it depends on how you are connecting to SQL Server. If you are using ADO, which is pretty common, then you might be able to take advantage of connection pooling, which basically means that many users can be processed using a few actual connections because the connections are getting re-used.-------------------It's a SQL thing... |
 |
|
|
|
|
|
Sql server7.0 Limitations