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 |
|
Jon G
Starting Member
31 Posts |
 Posted - 2005-10-08 : 15:12:58
|
| I have an application that I have written that uses a sql server database running under MSDE 2000 on a 2003 server.The application consists of many exe's that may run simultaneously and each of the exe's has a connection to the database.Example, if I have 50 concurrent users using the system, that could actually be 150 actual connections to the database.So, how many concurrent connections can the MSDE handle?thanksJon |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-10-08 : 16:15:53
|
| MSDE 2000 has a workload governor that may impact your application. read about it here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0ciq.aspas far as concurrent connections, it is the same as sql server standard (32,767). The workload governor kicks in anytime you have 8 simultaneous operations occuring in the database. Read the info in the link above for the details of how this works.You might want to google "MSDE" and "workload governor" for more discussion regarding this feature.-ec |
 |
|
|
Jon G
Starting Member
31 Posts |
Posted - 2005-10-08 : 16:41:30
|
| Thanks very much. That's just the info I was looking forJon |
|
|
|
|
|
|
MSDE - how many connections can it handle