Database Configuration for Maximum SharePoint 2010 Performan
Most of the SharePoint 2010 installations I’ve come across with use the standard and default configurations on the database server. However, the health and performance of your SharePoint farms are directly related to how your SQL Server databases perform. If the SQL Server databases are not performing well, that will translate to poor SharePoint performance. So, before you start spending more money into buying faster servers or upgrading your CPU and/or memory, you might want to check out this session first. We will learn how to properly configure a SQL Server instance for maximum SharePoint performance. We will look at understanding the underlying storage, proper database files placement, tuning the tempdb database database and other configuration settings that will help your SharePoint databases achieve optimum performance.
Sorry, there are no downloads available for this session.
Edwin Sarmiento is a Microsoft SQL Server MVP from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement – "To help people and organizations grow and develop their full potential as God has planned for them"
The video is not available to view online.