Capacity Planning in SharePoint Server 2010
March 1, 2011
“Storage and SQL Server Capacity Planning and Configuration (SharePoint Server 2010)” explains how to plan for and configure the storage and Microsoft SQL Server database tier in your Microsoft SharePoint Server 2010 environment. The article states:
“Because SharePoint Server often runs in environments in which databases are managed by separate SQL Server database administrators, this document is intended for joint use by SharePoint Server farm implementers and SQL Server database administrators. It assumes significant understanding of both SharePoint Server and SQL Server.”
With that as a given, the capacity planning is outlined through several steps. There is a summary of the databases installed with SharePoint Server 2010 and directions for estimating the IOPS. The article recommends that you run your environment on the Enterprise Edition of SQL Server 2008 or SQL Server 2008 R2.
The write up advises you on choosing a storage architecture, disk types, and RAID types. There is a table of guidelines to estimate memory requirements and some advice on network topology requirements. The Configure SQL server section advises that SharePoint Server 2010 was meant to run on several medium-sized servers rather than a couple of large ones. The final point in the article provides general guidance for monitoring the performance of your system.
This article makes me glad that I am not a database administrator. With the huge volumes of data that are found on SharePoint, it can be difficult enough to wield as a front-end user. It reminds me that the more data one has, the more important indexing and semantics become for navigating the wealth of information that someone else plans how to store. Keep in mind that Search Technologies can assist you with your SharePoint capacity planning from the perspective of searchability.
Stephen E Arnold, March 1, 2011
For Search Technologies
Comments
-
- Subscribe to Beyond Search
Feature archive
News archive
-
