Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'd like you all to give me hints and advise on the following scenario:

We are considering using Microsoft's SQL Server 2008 R2 Express for a business Web Application.

The Web Application won't have more than 10 CRUDs, and won't have a high data traffic, all of them are simple web forms. About data scalability, the Web Application is basically focused on employee data, like personal information, vacancy control, and the daily frequency control.

From what I've seen, I've estimated a maximum of 5 simultaneous users, generating data traffic.

And also, our employee table should hold a maximum of 100 records.

As to physical limitations I think we're fine, since I don't think a maximum of 100 employee should generate 10 GB for the next, say, ten years? But since I've read that the Express edition only manages 1 GB of RAM and uses only 1 CPU, I thought it'd be best to ask.

Do you think it can manage to keep up a good response and performance in this case?

So please advise on using SQL Server 2008 R2 Express or some other database manager. Just keep in mind that it has to be free.

Aditional info:

  • Windows Server 2008;

  • 4 GB of RAM;

  • 1 TB HD.

share|improve this question

3 Answers 3

up vote 5 down vote accepted

That currently sounds perfectly sufficient. Check out the limitations of the Express version so you know if/when you'll reach a point where you'll need to seek out a more encompassing version.

share|improve this answer

I believe Express should be more than adequate. Once your database is larger than 1GB it won't all fit in memory, but unless your hard drive is 5400 RPM and your users are very particular it is quite unlikely they would ever know the difference. It doesn't sound like you'll get past 1GB in any feasible time frame anyway...

share|improve this answer

To be blunt, my HTC phone would run that load. Whilst playing Angry Birds.

I wouldn't worry about Express edition of SQL Server

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.