Microsoft Windows-based applications and data are growing in size and complexity, reaching the limits of their architecture and scalability. Download this whitepaper to read the benefits of updating database applications to the Microsoft SQL Server 2005 platform with the HP Integrity family of 64-bit servers.
Migrating to HP Integrity servers and Microsoft SQL Server
2005
Executive summary............................................................................................................................... 2 Audience............................................................................................................................................ 2 Why HP Integrity servers?..................................................................................................................... 3 Why SQL Server 2005?....................................................................................................................... 4 Migrating to HP Integrity servers............................................................................................................ 5 Migrating from 32-bit only ................................................................................................................ 5 Migrating from 64-bit only ................................................................................................................ 6 Mix of 32- and 64-bit ....................................................................................................................... 6 HP Integrity systems family ................................................................................................................ 7 HP Integrity configurations................................................................................................................. 8 Storage guidelines ......................................................................................................................... 11 SQL Server 2005 update process........................................................................................................ 13 Pre-migration Upgrade Advisor Analysis Wizard ............................................................................... 13 SQL Server 2005 Update process steps............................................................................................ 26 Post-update checks ......................................................................................................................... 45 Testing summary................................................................................................................................ 47 Software versions........................................................................................................................... 47 Databases and workloads used ....................................................................................................... 47 Testing results ................................................................................................................................ 48 For more information.......................................................................................................................... 49
Executive summary
Always a critical part of the IT infrastructure, databases are at the heart of a number of trends in IT: . Microsoft® Windows® -based 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. - Systems such as large e-commerce Web sites that must respond to spikes in demand from large numbers of users and a high volume of transactions will also see improvement. With these applications, large amounts of memory are required to maintain connection context for every database object opened by a user. - Data mart consolidation is also common to help utilize hardware resource more cost effectively.
With the introduction of 64-bit hardware and software for Windows, organizations can deploy new applications or migrate existing ones to faster, more efficient technologies. The Intel® Itanium® 2-based HP Integrity server family, with Microsoft Windows Server 2003 for Itanium-based Systems (hereinafter referred to as Microsoft Windows Server 2003) and Microsoft ... [download for more]
