SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 MSSQL 2005 Express for web application?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

multiplex77
Starting Member

Singapore
24 Posts

Posted - 09/10/2007 :  06:18:38  Show Profile  Reply with Quote
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 indexing
5. 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

Sweden
30208 Posts

Posted - 09/10/2007 :  06:20:24  Show Profile  Visit SwePeso's Homepage  Reply with Quote
1. Yes
2. No



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

multiplex77
Starting Member

Singapore
24 Posts

Posted - 09/10/2007 :  06:44:38  Show Profile  Reply with Quote
Thanks!!
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30208 Posts

Posted - 09/10/2007 :  06:51:52  Show Profile  Visit SwePeso's Homepage  Reply with Quote
14,000 visits per month, is about one visit every three minutes.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

multiplex77
Starting Member

Singapore
24 Posts

Posted - 09/10/2007 :  07:28:38  Show Profile  Reply with Quote
That's very low, I presume? At what point would SSE be insufficient then?
Go to Top of Page

Zoroaster
Aged Yak Warrior

USA
702 Posts

Posted - 09/10/2007 :  09:30:03  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000