Optimizing HP Servers with Microsoft SQL Server 2008
Click here to download now
Overview: With the introduction of SQL Server 2000, then with SQL Server 2005, and now with SQL Server 2008, Microsoft is providing its database engine in a 64-bit version. Processors, such as the Xeon and the Itanium from Intel, or the Opteron from AMD, provide 64-bit capabilities that can be used by Windows Server and SQL Server.
With 64-bit configurations, consolidating the corporate data on one single device is now a valid option. The financial benefits are significant: a lower total cost of ownership and a higher return on investment. From the technical standpoint, having multiple databases exposed through multiple database engines presents new challenges: first, the data isolation must be guaranteed between the applications. Grouping all the data onto one server also requires a very high level of availability. Another challenge is to guarantee suitable response times for all the applications that will be accessing their data from the same server. Resource management technologies are essential features to ensure that the service level agreement (SLA) is fulfilled and the resources are well optimized and dispatched according to the need.
The objective of this whitepaper is to show how Microsoft SQL Server 2008, specifically on 64-bit platforms, together with the resources and and technologies available on HP servers offer unique solutions for consolidating corporate data.