February 28, 2008 at 5:40 am
Database about 500 mb, 25 users. on Windows Server OS, can Express handle this reliably, anyone using it in a similar situation ?
March 4, 2008 at 12:05 pm
My experience is that Express can handle a 2.7 gb database that has a 9 million row table and several other dbs and 75 users very well.
The db is living on a very healthy IBM xSeries box
March 4, 2008 at 12:41 pm
Generically - SQLExpress is limited only to a single processor and 1GB RAM. It's not techinically limited on DB size or # of connections. So - assuming your activity stays "simple" and does not impose a large footprint on the RAM - sure - it can take quite a bit.
If on the other hand you start implementing a lot of paging on large tables, etc...then no - the RAM requirements will turn Express into a "dog" you will need to replace.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 4, 2008 at 1:06 pm
Express Does have a 4 GB db size limit as well, however I'd be more looking at limitations involved around no SSIS, no Sql Agent job Service, and limited backup and restore capabilities (no mirroring, log shipping). Depending on how critical these may be would determine if you can actually use express. See the below link for ease of comparison.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
March 4, 2008 at 1:28 pm
Luke L (3/4/2008)
Express Does have a 4 GB db size limit as well, however I'd be more looking at limitations involved around no SSIS, no Sql Agent job Service, and limited backup and restore capabilities (no mirroring, log shipping). Depending on how critical these may be would determine if you can actually use express. See the below link for ease of comparison.http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Missed the part about the 4GB limit on files. thanks!
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 4, 2008 at 1:32 pm
Probably not a big consideration since the OP only has a 500MB db right now, but I figured it should be stated. It could be a problem depending on the expected amount of data to be added and the growth rate etc, but if express will do everything else you need right now, Purchasing Workgroup or Standard Ed could be something that might be put off for a few months or years depending on how tight the budget is currently...
The biggest draw backs for me are no SSIS and scheduled tasks.
March 4, 2008 at 2:32 pm
SSIS is missed but there is an open source scheduler that works very well called SQLScheduler at lazycoding.com
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply