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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2007-02-08 : 17:57:23
|
| GurusMy hosting co is telling me that they will allow 50 concurrent connections on my DBWhat does that mean?Plz helpregardsNitin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-08 : 18:02:38
|
| http://dictionary.reference.com/browse/concurrentSo they will allow 50 different spids to be connected. You could have thousands of users. They just can't all be connected at the same time.Tara Kizer |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-08 : 18:03:48
|
it means if you have 50 connections open, the next one will be denied.
www.elsasoft.org |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2007-02-08 : 18:20:09
|
| hi50 is a very small figure??Regards |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-08 : 18:22:22
|
| It depends on how you code your application. If you use connection pooling, then 50 sounds fine to me. We've got thousands of users in our applications and I'd say we've only got around 50 concurrent users on each SQL Server. We do use connection pooling though.Tara Kizer |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2007-02-08 : 18:23:50
|
| Thanks TaraRegardsNitin |
|
|
|
|
|
|
Connections with a DB