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

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

Best practices for using Microsoft SQL Server 2008 Data Compression with HP ProLiant and Integrity servers and HP StorageWorks E is published by Hewlett Packard Corporation, these other resources are also available from Hewlett Packard Corporation:

• Backup and Recovery Best Practices for Microsoft SQL Server 2005
• Consolidating Microsoft SQL Server with HP PolyServe: The User View
• Easing the Migration to Microsoft SQL Server 2005
• High availability for SQL Server 2005 using array-based replication and host-based mirroring technologies
• Implementing Microsoft Windows Server 2008 Hyper-V Release Candidate 0 on HP ProLiant servers
• OLTP reference configuration guidelines for Microsoft SQL Server 2005 on HP Integrity servers
• Optimizing HP Servers with Microsoft SQL Server 2008
• Optimizing HP servers with Microsoft SQL Server 2008
• Reference configurations for Microsoft SQL Server 2005 data warehousing using HP Integrity servers
• SQL Server Consolidation Demo - DeskTV
• SQL Server Consolidation: Insights from Customers, Analysts & HP
• The Essential Guide to Solving Server Sprawl

• 10 Really Good Reasons To Use Predictive Analytics
• 10 Strategies for Choosing a Midmarket ERP Solution
• 10 Ways Predictive Analytics Can Help You
• Achieving Compliant Manufacturing Excellence through Real-time Performance Management and Continuous Improvement
• Advances in Data Warehouse Performance
• An Improved Architecture for High-Efficiency, High-Density Data Centers
• APC Interactive TradeOff Tools
• APC Tech Talk Link
• Best Practices for Enterprise Data Governance- 2006-07 Scorecards
• Big Blue Touts Dynamic, Balanced Warehousing
• Business Intelligence and Enterprise Performance Management: Trends for Emerging Businesses
• Data Center Management Software - Virtual Media Tour
• Data Replication and CDP for IBM AIX Environments
• Data Replication and CDP for IBM AIX Environments
• Database Trends and Applications
• Disk-based Backup & Recovery: Making Sense of Your Options
• DM Review
• DOCUMENT
• Equifax Master Data Management Case Study
• ERP Buyer's Guide
• Essential Guide to Disaster Recovery in System i (AS/400) and AIX environments
• FierceContentManagement
• Get Serious About SOA Governance: A 5-Step Action Plan for Architects
• Green Computing Beyond The Datacenter
• How Can an automated Program Office Solution Help My Agency Meet its Performance and Reporting Goals?
• IBM Systems Energy Efficiency
• IBM Workplace Forms eKit
• Innovate Over SAP With Service-Oriented Architecture, Business Process Management, and Enterprise Social Computing
• KMWorld
• Leading Gaming & Entertainment Company Increases Loyalty with Equifax Database Solutions
• Microsoft Exchange Best Practices
• Multi-Entity Master Data Management: The 4th Generation of MDM
• On-Demand Security Audit – Free 14-Day Trial
• Oracle Magazine
• The Common Resource Gap Facing Midsize Companies and the Time-Tested Alliance that Can Save Them
• The Federal Case for Application Delivery Networks
• The Instantly Responsive Enterprise: The Marriage of Business Process Management and Complex Event Processing
• The Roadmap to Virtual Infrastructure: Practical Implementation Strategies
• The System i Challenge
• Thin Provisioning: The Secret to Achieving Operational Efficiency in the Data Center
• What Does Green Really Mean for IT?