Helping ordinary people create extraordinary websites!

Best practices for using Microsoft SQL Server 2008 Data Compression with HP ProLiant and Integrity s
Friday, 19th September 2008
Published by:


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.


 4 Votes

Related White Papers:
» 'Think Lean' When Developing Management System Documentation
» 'Think Lean' When Developing Management System Documentation
» 2010, The Year of Data Center Transformation
» 2010, The Year of the Data Center Transformation
» Fast, Affordable, Agile - The Case for SaaS BI
» A Comprehensive Framework for Securing Virtualized Data Centers