Get Our Newsletter

Email:

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


Best practices for using Microsoft SQL Server 2008 Data Compression with HP ProLiant and Integrity s 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.

» Get this free white paper now! «

---

 | |

---

IT Categories

» Computers » Data Management » Information Technology » Internet » Network Communications » Security » Software and Development » Storage

Related White Papers:
» Centralized Data Backup: It Doesn't Have to Cripple Your WAN
» An Improved Architecture for High-Efficiency, High-Density Data Centers
» Choosing a Reliable and Powerful IT Infrastructure at a Price You Can Afford
» Data Center Management Software - Virtual Media Tour
» From Spreadsheet Chaos to an Integrated BPM Application in Six Steps
» Information Architecture in Microsoft Office SharePoint Server

characters left.