Visit My Sponsors - SharePointAds







Easily Secure SharePoint Documents
Based on Metadata. By Titus Labs.



SharePoint Joel's SharePoint Land > Posts > Small SharePoint Deployments
Small SharePoint Deployments

One thing I haven't posted about is the small deployments.  Yesterday I talked to someone deploying SharePoint for 15 users.  Now that's a different set of challenges.  I ran into them after going through my Governance deck, which I'm sure overwhelmed them a bit.  By default I think in terms of enterprise scale and perspective.  That's actually one reason I have enjoyed co-presenting with Shane Young (who's moved on to presenting with other people lately, but he is an early founding member of my fan club.) for that reason.  Shane deals with the small businesses all the time.  I enjoyed getting his perspective as it applied to the SMB.  A question was asked yesterday about a default preconfigured installation of SharePoint for small business.  I had no idea.  If there is such a thing I would be interested in it.  I hope they aren't running basic mode, otherwise I would have a hard time suggesting it's usage.

Issues with the small deployments

So I was in this session in Rochester yesterday and I couldn't shut up.  It was hard to sit in the audience hearing someone suggest small farms by default.  In all my years I'd never heard of *Real* production environments in the small mode with the exception of those shadow apps we hear about (those under the radar some small department doing something without IT's approval or knowledge).  I have heard of Small Business Server, but rarely did I run into people at conferences in this config.  To my surprise 5 people raised their hands as currently running in that config (in a crowd of 35)!  Whoa, it did shock me just a bit.  Going to these smaller more local events has given me a bit of a different perspective. 

Later in the session the instructor was talking about how .DOCX isn't indexed by default.  What!!! I've never heard of that.  I had to think about this for a while.  Of course WSS and MOSS both index the Office 2007 file formats by default for the most common apps like DOCX, PPTX, and XLSX.  Is there something in a SQL express or Basic Windows Internal Database Engine deployment where search is off?  Obviously the 2003 or WSS 2.0 doesn't have those extensions and there's a KB on that one http://support.microsoft.com/?kbid=944445  This KB tells you to install Office on the Server.  Don't do that!!! Install this... The Microsoft Ifilter pack which does includes docx, .pptx, .xlsx, Office 2007 extensions plus many you DON'T get out of the box with WSS 3.0 and MOSS like .zip, .one, .vdx, .vsd, .vss, .vst, .vdx, .vsx, and .vtx.  I see this as an important step.  You want Visio and One note indexed right?

What can a small farm do?

It is not unreasonable to suggest that a small farm could handle 5000 unique users over a months time with a few hundred concurrent connections (essentially thousands of .NET requests per minute) and millions of page views per month.

While a small farm with one web front end and a back end full SQL server deployment could service up to 5000 users with periodic access for a departmental publishing site, but I haven't encouraged it.  Why?  It's the time to setup and reconfigure and having to mess with database connections and so on that discourages me.  With Virtual Images with VMWare or HyperV, I'm much more encouraged from a hardware perspective that you can do a lot with 2 physical boxes, but I still avoid the single image SharePoint deployment.  Those that do will find things run perfectly ok, until they have an outage and then they are down, and they are down HARD.  That first farm restore will be a nightmare, and you WILL curse SharePoint.  Not just for failed search index, but trying to get your databases back to the way they were, all sorts of decisions you won't know how to weigh out.  Disaster Recovery on SharePoint is not easy and having one SharePoint server actually DOES make it harder, not easier.  Those of us doing this longer realize that.  We realize failures will happen, and the way to mitigate failures is to make sure we are fault tolerant.  Not only accounts and services, but all the things you don't learn about timer services, deployment packages, and maintainability.  These things won't come up with your single box deployment, and you'll be missing out on many best practices.  I would suggest that you will spend more time in supporting your single box than you would 2 or 3 SharePoint boxes.  Crazy?

Check out this TechNet article on HyperV that compares performance of a small farm that's physical verses virtual.  How did that sneak out?

Comments

Consultancy Companies

There are alot of consulting companies that are pushing the single server approach to SharePoint.  Primarily because clients don't want to spend so much on licenses and server/hardware costs.  There was one MS Gold Partner that recommended single server SharePoint deployments!  They wanted short term business.  I even overheard them saying that with this configuration, the support issues they would have would ensure repeat business for them. 
 
So yes, governance planning and following best practices is important and what consultants/companies should do.  Its unfortunate when ppl buy into SharePoint with those of spending little, not following best practices and laying the foundation of chaos in the process.
at 2/11/2009 11:49 AM

Great to hear about small deployments!

We are a small conservation non-profit org. and I'm their 1-man IT shop.  We run Small Business Server and got a 2nd server to run MOSS & SQL 2005 to handle our sprawl of files, and provide a means for the scientists to work together in a collaborative environment.
My biggest frustration has been that the vast majority of blogs and sites I can find on SP are geared toward medium- to large-enterprises that I just can't relate to.  I'm much closer to the skill level at endusersharepoint.com, but see a void in the admin side.  That site is great for IKW's and Site Owners, but what about shops like mine.  We're out here and maybe more common than is thought.
I'm glad to see this post and will continue to seek out others that can help me or serve as a reference.
I'll continue being a faithful reader of your blog, and look forward to other posts on this, or a related subject.
at 2/11/2009 12:55 PM

Great to hear about small deployments! (change 1)

(Forgot my name)
 
Mike Webb
south-central Nebraska
at 2/11/2009 12:57 PM

Great to hear about small deployments! (change 1)

(Forgot my name)
 
Mike Webb
south-central Nebraska
at 2/11/2009 2:00 PM

Add Comment

 Social Comments

Post Comments to your Facebook Profile Post comments to twitter or on SharePointJoel.com
blog comments powered by Disqus
Share

Blog (RSS)

Follow on Networked Blogs Facebook

Recent Comments

Powered by Disqus
Subscribe by Email or RSS

Contact me

 20 Recent Posts

Effective SharePoint 2010 Upgrade Q&AUse SHIFT+ENTER to open the menu (new window).New
How Microsoft Is Doing Records ManagementUse SHIFT+ENTER to open the menu (new window).New
Free Webcast: Get to SharePoint 2010 – Strategies for Effective Upgrades and MigrationsUse SHIFT+ENTER to open the menu (new window).
SharePoint 2010 and SQL Hotfix DependenciesUse SHIFT+ENTER to open the menu (new window).
Aptillon SharePoint Consulting GeniusUse SHIFT+ENTER to open the menu (new window).
Really, A SharePoint Training Cruise?Use SHIFT+ENTER to open the menu (new window).
Updated Guidance on SharePoint 2010 Upgrade and the FAB 40 application templatesUse SHIFT+ENTER to open the menu (new window).
SharePoint 2010 Upgrade Decision TreeUse SHIFT+ENTER to open the menu (new window).
We’re Serious - Don’t Modify Your Database or Face ConsequencesUse SHIFT+ENTER to open the menu (new window).
Remove/Deactivate a missing feature for a cleaner upgradeUse SHIFT+ENTER to open the menu (new window).
Free Webcast: Best Practices for Upgrading and Migrating to SharePoint 2010Use SHIFT+ENTER to open the menu (new window).
I’m in Utah today at the MOSSPit (SLC UG)Use SHIFT+ENTER to open the menu (new window).
Wish you had free end user training incorporated into your SharePoint environment?Use SHIFT+ENTER to open the menu (new window).
SharePoint Virtual Expo Networking EventUse SHIFT+ENTER to open the menu (new window).
Planning SharePoint Deployments with RACIUse SHIFT+ENTER to open the menu (new window).
Reaching out to the SharePoint Portuguese CommunityUse SHIFT+ENTER to open the menu (new window).
Kudos to Owen Allen @owenallenUse SHIFT+ENTER to open the menu (new window).
Practical Windows PowerShell for SharePoint 2010Use SHIFT+ENTER to open the menu (new window).
Project Server 2010 and SharePoint 2010 CoexistenceUse SHIFT+ENTER to open the menu (new window).
What’s Next in SharePoint LandUse SHIFT+ENTER to open the menu (new window).