Michael Noel’s ‘Building the Perfect SharePoint Farm’ at STP Montevideo
Published 01/23 courtesy of Bamboo Solutions Community
Before I get to Michael's session proper, I should explain that no, you're not imagining things, and that is indeed Michael Noel presenting in one of Mark Miller's signature Western shirts in the picture above. The short version of the story is that over dinner last night, Paul Swider made a bet with Michael (who hails from San Francisco) regarding the outcome of the San Francisco 49ers / New York Giants playoff game back home in the states. If San Francisco won the game, Paul would have to present his STP Montevideo session wearing Joel Oleson's iconic Egypt soccer jersey; if New York won, Michael would have to present his session today in Mark Miller's Western shirt. The New York Giants beat the San Francisco 49ers last night in the final minutes of overtime, hence Michael's unconventional appearance at today's session.
With Ricardo Munoz serving as translator, Michael Noel began his STP Montevideo session by explaining that he'd be sharing "best practices around how to setup the back-end infrastructure around SharePoint." Michael began with a brief overview of the three-tiered farm architecture, including Web, Service Apps, and data (the SQL tier), stating that "Each tier has its own architectural considerations, so you need to design around the unique needs of each of the three tiers."
Michael explained that the farm is the core unit of SharePoint, and his first recommendation was to avoid an "all-in-one," single-server approach. Michael said that having the database and SharePoint roles on separate servers is a better design, and that a four-server approach is the smallest farm size that is fully highly available, noting that "in many cases, these can be virtual machines." Michael considers the six-server farm to be "an ideal starting point," since such an approach allows you to "break off into the different tiers and have full high availability if you lose one of the servers." SharePoint scales very well so "you can build up, and build out the tiers," thereby distributing the load across additional servers.
Virtualization provides the most highly scalable environment, and allows you to easily add new servers to a farm, and Michael would later walk through that process (with a previously recorded demo, due to time constraints). Discussing virtualization architecture, Michael shared a slide with processer and memory guidelines, such as to never go below the recommended minimums. Michael then touched on some examples of virtualized designs, discussing the benefits and flexibility that virtualization provides: the single-server approach; two virtual hosts; and a mixed physical/virtual design, which is the best practice, with Michael's recommendation being that the data tier remain physical, while the SharePoint tiers are virtualized. Performance monitoring guidelines for each were shared in a slide which is available for download within Michael's deck.
Moving into his demo on farm provisioning with virtualization -which Michael typically does as a 15-minute live demo-Michael talked through the steps, from virtual server creation to its availability in the farm, while accompanied by a pre-recorded video.
Michael addressed the optimization and management of the data tier next, talking through a diagram that illustrated the environment. Discussing data management with remote BLOB storage (RBS), Michael explained that unmanaged data is not at all ideal for storing in a SQL database, so storing them remotely (i.e., outside the SQL server) is recommended as a best practice; doing so will dramatically reduce the size of your content databases.
Moving on to SQL database optimization, Michael recommended splitting the database files into multiple pieces, based on the number of processors on your SQL server ("to get better disk performance"), and to also "consider pre-sizing the content database files." Michael wrapped up by briefly addressing SQL database mirroring (which he recommends), explaining that there are three models that can be deployed in SharePoint: synchronous within a single data center, synchronous cross-data center, and asynchronous.
Recent SharePoint Questions
- sharepoint Q&A function
- Customize "Send To" menu in Sharepoint 2007
- Site is opening only on Server but not on other clients. How to fix this?
- Handy & Free of Charge SharePoint Tools
- One Document - two sites
- What is the difference between a document library and a form library?
- What is Collaborative Application Markup Language?
- • What is the difference between SharePoint Portal Server and Windows SharePoint Services?
- Why should you use SharePoint?
- Displaying columns
more sharepoint questions
More Articles By
Develop Mobile Applications for SharePoint with Mobile Entree - CMSWire
Develop Mobile Applications for SharePoint with Mobile Entree
CMSWire, CA
By Barb Mosher | Jun 5, 2009 Seeing as how SharePoint (news, site) is so widely used within the enterprise today, it's…
Bamboos Year in Review: Marc OBrien Introduces the Bamboo Online Applications Division
Editor's note: Last year we introduced the Bamboo Year in Review feature, kicking off with a note
While writing the final sentences of my post on how to create a SharePoint blog last week, I realized that I needed to circle back and spend some time… Mobile Entrée is installed as a SharePoint solution and is deployed as a series of features.
Top News Stories Make your plans now to attend the Best Practices Conference this August 24-26 in Washington, D.C. to ensure that you don't miss out on sessions presented by some…Working with the Admin Links on your SharePoint Blog
More Articles Under "News from Around the Web"
Guest Blog by H3 Solutions Jason Hall - Mobile Entrée, Taking a Look Under the Hood
SharePoint on Your SmartPhone, Android Moves to Laptops, Best Practices Conference Speakers List
Google Wave - A Developer's Eye View (The Register)
Last week, Google announced Wave, a…Announcing the Best Practices Conference Speakers List!
Most Viewed Content
