Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is it possible to build a "free" server (SQL Server Express + Sharepoint Foundation) when the number of concurrent users will be about 20 with the total number of about 100. Both SQL Server and Sharepoint will be running on the same Windows Server 2008 (not sure which edition yet). Will this work? Or I need to consider paid versions?

share|improve this question
    
what deployment will you install? The maximum amount of data you can store in this environment is 4GB. –  Thuan Aug 4 '11 at 2:43
1  
I think they bumped SQL Express up to 10gb and you can multiply that ad much as 10x if you implement RBS. –  Rob D'Oria Aug 4 '11 at 3:02

2 Answers 2

up vote 1 down vote accepted

Users will definitely not be an issie so you probably only need to be concerned with content volume. With SharePoint Foundation and SQL 2008 Express you have a 10GB limit but can implement RBS FILESTREAM OR 3rd party RBS provider to increase the amount of content you can manage in the environment...probably upwards of 75-100GB.

share|improve this answer

This should work. As Rob says, it is only going to be a problem if you put in huge amounts of content (unlikely given the number of users).

However, I wouldn't recommend using RBS (FILESTREAM) to get around the storage limit on SQL Express, other than to get around a particular 2007 upgrade scenario. I just don't think it is worth the trouble and complexity compared to the cost of a SQL Server licence, in my opinion. Can't see it being an issue though with that number of users - you have 10 Gb to play with.

share|improve this answer
    
You will definitley want to monitor your resources closely. 100 concurrent users browsing not much of an issue, 100 users uploading/download docs at the same time you may start to see issues with SQL keeping up. SQL Express is limited to utilizing only 1 CPU (core), and 1GB RAM. –  Jesus Shelby Aug 4 '11 at 13:36
    
He anticipates 20 concurrent users, but a valid point nonetheless. –  SPDoctor Aug 4 '11 at 18:11

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.