Last post Nov 19, 2005 10:20 PM by ralonso
Nov 17, 2005 01:29 PM|funknut|LINK
Nov 19, 2005 04:22 PM|funknut|LINK
Nov 19, 2005 06:35 PM|ralonso|LINK
Ok finally could get out of something I was struggling with (no worries
no cuts and bruises)
is no limitation on concurrent user (since there are so many factors comes into picture) and that is why what we tell is that
MSDE is optimized for 5 concurrent user (most of our testing specially load/stress testing are done on this)
When the number
increases basically depending on multiple other factors (hardware, database size, data optimization etc) you might start noticing the degradation in performance.
concurrent user here means when 5 queries come @ the same time so there could be 10 people connected but still the server is getting only 3 or 4 query @ the same time and in that case no effect would be evident.
Please let me know if this answer your question or you need more information/clarification.
sql express does not have the concurrent user limititation, it just limits the database size.
Nov 19, 2005 07:16 PM|tao_muon|LINK
If you have a license for MSSQL 2000, I'd wonder why you're not taking advantage of it.
Since the 2GB limitation on database size has been raised to 4GB, then I'd wonder why you wouldn't
consider fragmenting the portals to use separate instances of SQL2005.
This might be a deciding factor: (from:
There is no more workload governor, though if you are running Express on Windows XP Home or Windows 2000/XP Professional, and using named pipes to connect, you are limited to 5 and 10 simultaneous
connections, respectively. This is enforced at the OS level, and is not a new limitation in SQL Server Express; it also exists in previous versions of MSDE and SQL Server Personal Edition.
There will be a limited graphical management tool for SQL Express, however it will not ship until as late as mid-2006
(Community Technology Preview version available here) . In the meantime, you
can access SQL Server Express through SQLCMD, the new command-line admin interface to SQL Server; with Management Studio from any other SQL Server edition; or, from a subset of the applications listed in
Nov 19, 2005 09:30 PM|bhopkins|LINK
Nov 19, 2005 10:20 PM|ralonso|LINK