Hi !
What is the max number of connections in sql server 2000 MSDE ?
I have found three opinions on the web: 5,8 and unlimited(32,768...)
Which is true ?
/hakan
I don't think there is any limit to the number of connections. . .
there is a throttle on performance based on number of concurrent connections. the actual number that triggers the throttle i beleive depends on build/sp.
that being said. . . if you build your app correctly and design you database properly, you could probably service 100 to 200 concurrent users of your windows app without seeing a performance hit and thousands of concurrent users of a web app. thats just an opinion, don't ask me to prove it. but I will keep repeating that until someone from MS tells me differently.
but, build you app/db improperly and it doesnt matter which version of sql server you use. performance is going to suck any way.
No comments:
Post a Comment