Best practices for using Microsoft SQL Server 2008 Data Compression with HP ProLiant and Integrity servers and HP StorageWorks EVA8×00

Learn best practices for optimizing your SQL Server 2008 environment by maximizing your storage investment, CPU and server memory use.
Learn how to optimize your SQL Server 2008 environment with data compression, a new feature of SQL Server 2008 that provides more efficient data storage and improved performance (due to lower I/O demands). HP conducted extensive testing to determine the impact of data compression on OLTP and data warehouse workloads; this report documents the best practices for its configuration, deployment, and usage in an enterprise environment.

By following the tested, technical best practices in this report, you can:

• Maximize your storage investment through improved use: Data compression reduces OLTP and DW data space by as much as 50% for targeted tables when using page-level compression.
• Optimize CPU use: Data compression on an existing table is very CPU-intensive, especially when using page-level compression. Consider activating the data compression on production databases outside peak hours and, ideally, when no load is applied to the server.
• Optimize server memory use: Data compression significantly reduces memory consumption.

Click here to Download

Related Magazine :

1. OLTP reference configuration guidelines for Microsoft SQL Server 2005 on HP Integrity servers
2. Reference configurations for Microsoft SQL Server 2005 data warehousing using HP Integrity servers
3. Microsoft Exchange Server 2003: Best Practices for Data Storage Setup
4. Symantec Backup Exec Quick Recovery and Off-Host Backup Solutions for Microsoft Exchange Server 2003 and Microsoft SQL Server
5. Optimizing HP Servers with Microsoft SQL Server 2008

Like this post? Subscribe to my RSS feed and get loads more!