Designing a Microsoft SharePoint 2010 Infrastructure Vol 2 part 24. 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. | Designing a Maintenance and Monitoring Plan 13-35 Lesson 4 Considerations for the Maintenance and Monitoring of Associated Technologies Database Management IIS Management Systems Management Discussion Planning for Associated Technologies SharePoint 2010 relies on SQL Server to provide database hosting and IIS to provide Web services. You must include these associated technologies in your maintenance and monitoring plan. If any issues arise in any of these applications they may cause a catastrophic failure of your SharePoint 2010 infrastructure. Objectives After completing this lesson you will be able to Describe aspects of database management that you should perform to maintain SharePoint 2010. Describe aspects of IIS management that you should perform to maintain SharePoint 2010. MCT USE ONLY. STUDENT USE PROHIBITED 13-36 Designing a Microsoft SharePoint 2010 Infrastructure Describe how System Center Operations Manager can support SharePoint 2010. Discuss maintaining and monitoring the technologies that are associated with SharePoint 2010. MCT USE ONLY. STUDENT USE PROHIBITED Designing a Maintenance and Monitoring Plan 13-37 Database Management Key Points For SQL Server databases to perform at optimal levels it is recommended that SharePoint 2010 administrators conduct routine maintenance on each database. In large organizations SharePoint 2010 administrators may not perform database management tasks themselves. Instead they must liaise with the database administrator DBA team to ensure that appropriate maintenance and monitoring is performed for the SharePoint 2010 databases. These routine database maintenance tasks are often overlooked because they are redundant tedious and time-consuming. Moreover SharePoint 2010 administrators are overwhelmed with many other tasks throughout the day. In recognition of these issues Microsoft has provided a way to automate these daily tasks with a SQL Server maintenance plan. A SQL Server maintenance plan performs a .
