Best practices for using Microsoft SQL Server 2008 Data Compression with HP ProLiant and Integrity servers and HP StorageWorks EVA8x00, Free Hewlett Packard Corporation Best Practices Report

Request Your Free Best Practices Report:

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

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.

Geographic Eligibility: USA

Publisher: Hewlett Packard Corporation

Other Resources from: Hewlett Packard Corporation

Tags: configuration, data, data privacy, data warehouse, investment, memory, server, server virtualization, sql, sql server, storage, warehouse,