OLTP reference configuration guidelines for Microsoft SQL Server 2005 on HP Integrity servers

OLTP reference configuration guidelines for Microsoft SQL Server 2005 on HP Integrity servers This white paper describes a range of reference configurations to support mid to large online transaction processing (OLTP) solutions, capitalizing on the scalable power of HP Integrity 64-bit systems and Microsoft SQL Server 2005 (64-bit). Always a critical part of the IT infrastructure, databases are at the heart of a number of trends in IT:Microsoft® Windows® applications and data are growing in size and complexity. Some applications running on 32-bit platforms may be reaching the limits of the architecture, specifically regarding scalability number of processors and amount of addressable memory.Organizations are now able to migrate complex solutions from high-cost proprietary systems to lower-cost Windows-based systems.Organizations are consolidating applications to fewer servers to simplify critical data center operations. Consolidation can reduce cost, management complexity, and physical space requirements in the data center.The objective of these reference configurations is to:Reduce the time to purchase SQL Server 2005 configurationsReduce the time to implement SQL Server 2005 databasesReduce the risk to implement SQL Server 2005 databasesDetailed configuration information is provided on the:Reference configurationsStorage configurationSQL Server setupBills of Material

OLTP reference configuration guidelines for Microsoft SQL Server 2005 on HP Integrity servers 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
• Best practices for using Microsoft SQL Server 2008 Data Compression with HP ProLiant and Integrity servers and HP StorageWorks E
• 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
• 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?