HP and Microsoft engineers have worked together for months optimizing new solutions for data warehousing, BI and database consolidation, and the end result —
HP Business Data Warehouse Appliance, Optimized for SQL Server 2008 R2, a tightly integrated, pre-installed solution for small and medium sized data warehouses, recommended up to 5TB. This solution is fully compliant with our family of Data Warehouse Fast Track solutions. The solution runs a highly optimized installation of SQL Server Enterprise, with additional tuning, and management tools specifically created for the appliance. This solution is recommended for customers looking for:
- A high performance Data Warehouse, optimized for energy efficiency and lower cost
- 100% compatibility with SQL Server, running on HP hardware
- Can be deployed in minutes and is
- Pre-installed and tuned with all the hardware, software and management tools for instant use after unpacking.
HP Database Consolidation Solution, Optimized for SQL Server 2008 R2:
The reference architecture will help customers rapidly deploy a server rack that can support hundreds of database workloads in virtual machines, and run SQL Server in a Private Cloud. The solution is best suited for customers looking to:
- Consolidate hundreds of database servers, with no upgrading or updating the database (migrated via virtualization)
- Deploy SQL Server with the full benefits of private cloud — elasticity, resource pooling, self-service, and control and is pre-installed and tuned with all the hardware and software
- Optimize high performing database workloads. Our engineers analyzed hundreds of real life SQL Server instances, to ensure that hundreds of SQL Server instances could run on each rack, with an optimum mix of CPU, memory, and IO, to ensure the optimal level of performance. We found that generic hardware configurations did not have any of the hi IOPs required to sustain large numbers of database workloads
- Start reaping the benefits of running SQL Server in a Private Cloud, offering elasticity, self-service, and resource pooling, through tight integration of Hyper-V, System Center and SQL Server.
For more information, please visit HP.
[Source: SQL Server Team Blog]