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 |
|
multiplex77
Starting Member
24 Posts |
 Posted - 2007-09-10 : 06:18:38
|
| Hi,I'd like to get the experts' advice on whether SQL server 2005 Express edition (SSE) is suitable for medium scale web applications. I have looked through the reviews of SSE. From what I understand, its limitations over the MSSQL 2005 Standard are:1. SSE limits database size to 4GB and memory to 1GB.2. Support for only 1 CPU.3. No analysis or reporting services.4. No full text indexing5. No SQL Agent.I have a web application that is currently running on a shared web host with a shared MSSQL 2000 database. I'm thinking of shifting to a Virtual Private Server, where I can install SSE for free. Currently my app has about 14,000 page views a month, and each of them pulls out data from the database. I don't use any analysis or reporting services, or full text indexing or SQL Agent (for now).My questions:1. Is 1GB memory sufficient for this type of application?2. Is there any reason I should not be using SSE for my type of application?Thanks in advance for the help. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-10 : 06:20:24
|
1. Yes2. No
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
multiplex77
Starting Member
24 Posts |
Posted - 2007-09-10 : 06:44:38
|
| Thanks!! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-10 : 06:51:52
|
14,000 visits per month, is about one visit every three minutes.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
multiplex77
Starting Member
24 Posts |
Posted - 2007-09-10 : 07:28:38
|
| That's very low, I presume? At what point would SSE be insufficient then? |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-10 : 09:30:03
|
The no SQL Agent is a bit of a pain, but there are definitely other ways to handle jobs. Overall it sounds like an excellent choice.
Future guru in the making. |
|
|
|
|
|
|
MSSQL 2005 Express for web application?