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 |
|
manikandan
Starting Member
35 Posts |
 Posted - 2003-03-26 : 05:12:40
|
| Hai Guys,spid is declared as smallint in the sysobjects table....Will it have any effect on number of users (sessions) who are logging into the machine...Is it that only 32 thousand user sessions could be open at a point of time....cheersmanikandan |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-26 : 05:38:30
|
| Do you need more ?Damian |
 |
|
|
manikandan
Starting Member
35 Posts |
Posted - 2003-03-26 : 05:56:18
|
| Hai MerkinIt will be great if i know on whether it is the maximum limit as a client of mine says that there could be around 40K users using the machine....But when i said concurrent, he is telling me that it has to handle also. So, i need to know the answer even though there will hardly be more than 800 ppl at a same point of time...But tell me, FIFA & Olympic sites should have had more hit than this at the peak time...I know that they are not using SQL Server. But is it the maximum.cheersmanikandan |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-03-26 : 07:05:03
|
Hello.Quote from BOL:quote:
SQL Server allows a maximum of 32,767 user connections
Honestly, you should try using connection pooling. Each connection uses about 40 kilobytes of memory. 32767*40000 = 1 310 680 000That's 1,3 GB only for client connections. Not a good scenario I think.BTW, large sites such as those you mentioned surely use connection pooling of one kind or another. They also probably have quite an advanced setup (clustering etc.) and some kind of application servers (MTS, bea weblogic etc.).Edited by - andraax on 03/26/2003 07:07:18 |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-26 : 07:55:57
|
Yeah, what Andraax said  Also, large sites like that would implement a whole bunch of caching so not every page view would mean a database hit.Damian |
|
|
|
|
|
|
SPID being Small Int