Visit My Sponsors - SharePointAds







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



 Hottest Content

 Latest on Top 100 SharePoint Blogs
 Top SharePoint Storage Resources
 SharePoint Key Capacity Planning Resources
 SharePoint Podcasts, Screencasts, and Videos
 What NOT to store in SharePoint
 Hot Debate: Custom Site Definitions
 Disaster Recovery and Backup/Restore Resources
 Looking for SharePoint Speakers - Joel's Session List
 Free Blog Widget Site Search Components
 RealTime Twitter SharePoint League Stats
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

Upgrading to SharePoint 2010 with PowershellUse SHIFT+ENTER to open the menu (new window).
SharePoint Saturday Jordan 2010 and Session DownloadUse SHIFT+ENTER to open the menu (new window).
SharePoint 2010 Site Definition Upgrade Discussion with Microsoft’s Sean LivingstonUse SHIFT+ENTER to open the menu (new window).
Upgrade SharePoint 2003 to 2010 - Free Tech PreviewUse SHIFT+ENTER to open the menu (new window).
TEC2010 SharePoint Conference Updates, New Interactive Whiteboarding Track, Contest, Discount and Free PassUse SHIFT+ENTER to open the menu (new window).
SharePoint 2010 Upgrade Simplified - Q & AUse SHIFT+ENTER to open the menu (new window).
SharePoint 2010 Mobile and Windows Phone 7 Series Experience Drill DownUse SHIFT+ENTER to open the menu (new window).
SPTECHCON – Upgrade & Admin Session Decks and DetailsUse SHIFT+ENTER to open the menu (new window).
Simplify SharePoint 2010 UpgradeUse SHIFT+ENTER to open the menu (new window).
Should I Stay or Should I Go Now? SharePoint 2010Use SHIFT+ENTER to open the menu (new window).
10 Steps to Optimizing SharePoint Performance for IT AdministratorsUse SHIFT+ENTER to open the menu (new window).
Is SharePoint 2010 Ready for Enterprise Content Management?Use SHIFT+ENTER to open the menu (new window).
If you could go to one SharePoint Conference this year what would it be?Use SHIFT+ENTER to open the menu (new window).
The Great Virtualization Debate: What to do? SharePoint 2010 for LaptopsUse SHIFT+ENTER to open the menu (new window).
SharePoint 2010 Better Together with SQL 2008 R2 Database Enhancements Top 10Use SHIFT+ENTER to open the menu (new window).
SharePoint 2010 Upgrade Insight SeriesUse SHIFT+ENTER to open the menu (new window).
10 Reasons your CIO should NOT block Social NetworkingUse SHIFT+ENTER to open the menu (new window).
Understanding Feature and Code Depreciation for Upgrade to SharePoint 2010Use SHIFT+ENTER to open the menu (new window).
Free SharePoint Reports with No Server InstallUse SHIFT+ENTER to open the menu (new window).
How to Remove Corrupted SharePoint Sites – Preparing for SharePoint 2010 UpgradeUse SHIFT+ENTER to open the menu (new window).