Designing a Microsoft SharePoint 2010 Infrastructure Vol 1 part 19. This course is intended for IT Professionals who use Microsoft SharePoint 2010 in a team-based, medium-sized to large environment. While they may have implemented a SharePoint deployment, they have limited experience in designing a SharePoint infrastructure. They likely work as a senior administrator who acts as a technical lead over a team of administrators. Members of this audience should have at least 6 months experience with SharePoint 2010. | Planning for Performance and Capacity 3-47 Client Traffic Payload Office Web Apps High Medium PowerPoint Web broadcast High Low Microsoft Word 2010 and Microsoft PowerPoint 2010 client applications Medium Low Microsoft OneNote client application High High Outlook Social Connector Medium Medium Microsoft SharePoint Workspace 2010 High Medium In addition to planning capacity for SharePoint content storage you must plan capacity for additional SQL Server requirements such as transaction log storage. SQL Server creates and expands transaction logs as additional operations occur to content such as adding new content or making changes to existing content. You can manage transaction logs in two different ways Change the database model from full to simple. The simple database model automatically limits transaction log size by reusing space from committed transactions. Regularly back up the databases. During a SQL Server-aware backup task transaction log data is backed up and the transaction log is truncated to free space on the transaction log disk. This option requires enough disk space to enable the transaction log to grow sufficiently between backups. Note The database model also affects the recoverability of content databases and advanced features such as database mirroring. If you back up a database under the simple model you can only restore the database to the time of the backup. If you back up a database under the full model you have the capability to restore a database to the time of failure. The full model is required to support database mirroring. MCT USE ONLY. STUDENT USE PROHIBITED 3-48 Designing a Microsoft SharePoint 2010 Infrastructure How Capacity Planning Affects Farm Design Key Points After you have established the features that you want to provide in the solution and the dataset that you want to support you must consider the business requirements from a capacity standpoint to make decisions about storage requirements. For database servers you must .
