SharePoint® 2010 Administration: Instant Reference

Scale Out Database Servers

Any system is only as strong as its weakest link. In a SharePoint farm, the database role is usually the most common performance bottleneck. Furthermore, content databases store the data most critical to the users. These two reasons alone justify the importance of focusing on the database role to achieve greater performance and fault tolerance. Scaling the database also increases the total storage potential of the SharePoint farm.

Each of the sections that follow delivers at least one of these three goals: increasing performance, increasing fault tolerance, and increasing total storage space. When scaling, always keep your requirements in mind to ensure that you address the most important need. Whereas SQL Server Standard ...