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 |
|
jparker
Posting Yak Master
118 Posts |
 Posted - 2007-11-30 : 04:49:30
|
| MorningI have been searching hi and low on the web to try and find out typically which version of sql server should be used based on the number of concurrent users you will be having.I believe that Sql Server 2005 Express should only really be used for up to 10 concurrent users while I seem to remember that Standard edition supports up to approx. 33,000 connections.Does anybody have this information to hand as I need to write a business case to justify the potential upgrade.Many thanksJames |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
jparker
Posting Yak Master
118 Posts |
Posted - 2007-11-30 : 08:39:03
|
| Thanks for this but would you happen to know what the concurrency connections levels are for the other versions. I know that MSDE/Express are really only meant as development DBs but need to know how many standard, enterprise etc etc can handle. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 00:14:47
|
| 32767 if you want number, and I believe Microsoft removed concurrency connections limit from sql2k5 express. |
|
|
|
|
|
|
Concurrent Connections