Best practices for SQL Server 2008 in a SharePoint 2010 farm


How to optimize SQL Server 2008 to get best performance for SharePoint 2010 farm?

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

1. Use a dedicated server for SQL Server 2008
2. Configure specific SQL Server 2008 settings before you deploy SharePoint Server 2010

– Do not enable auto-create statistics on a SQL Server that is supporting SharePoint Server

auto-create statistics-on-a-SQL-Server

– Set max degree of parallelism (MAXDOP) to 1 for SQL Server instances that host SharePoint Server 2010 databases to ensure that each request is served by a single SQL Server process.

changing max degree of parallelism

Reference: http://msdn.microsoft.com/en-us/library/ms181007.aspx

3. Harden the database server before you deploy SharePoint Server 2010
4. Configure database servers for performance and availability
5. Design storage for optimal throughput and manageability
6. Proactively manage the growth of data and log files
7. Continuously monitor SQL Server storage and performance
8. Use backup compression to speed up backups and reduce file sizes

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

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s