Storage and SQL Server capacity planning and configuration for SharePoint Server 2010

Ever wondered if there is a formula for calculating content database sizes? Want to have a start into learning more about SQL design and database capacity planning for SharePoint 2010?

Luckily, there is an awesome Technet document on SQL server design and capacity planning and it covers some great points to consider when planning your storage with SharePoint 2010.

Microsoft has done some tests on a live environment and revealed database sizes, multipliers and other IOPS (Input/Output per second) stats on SharePoint 2010 databases.

It also talks about disk selection and prioritising your data among different type of disks.

I liked reading about the SQL counters to monitor too.. helps SharePoint Admins learn to communicate better with their DBAs!

Heres the article:

http://technet.microsoft.com/en-us/library/cc298801.aspx

 

One thought on “Storage and SQL Server capacity planning and configuration for SharePoint Server 2010

Leave a Reply

Your email address will not be published. Required fields are marked *