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

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 request your free White Paper!

Publisher: