แชร์ผ่าน

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

  • บทความ

image

This is a new CFT SQL Server 2008 whitepaper

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 whitepaper documents the best practices for its configuration, deployment, and usage in an enterprise environment.

image

By following the tested, technical best practices in this paper, 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.

Whitepaper...

image