|
|
|
|
|
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
|
|
|
|
|
|