Qualify for your FREE Issues!

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

Description: 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.

Publisher: Hewlett Packard Corporation