Reference Architecture for High Performance SQL Server

HP and Microsoft engineering teams have worked together to create a reference architecture to Accelerate Online Transaction Processing (OLTP) database workloads with a fully-flash based HP/Microsoft architecture
and achieve significant performance increases, simplified database manageability, and industry leading TCO.

The HP OLTP RA, built on HP ProLiant DL980 servers and HP VMA-series 3210 Memory Arrays provides:
• 350–700k sustained input/output operations per second (IOPS)
• As much as 10x faster time to database production: with faster warm-up times and reduced back-up and re-indexing times
• Reduces operational costs with a single rack saving on power and cooling requirements

Featuring the PREMA architecture in the HP ProLiant DL980 server
• Balanced scaling – world record performance enabled by Smart CPU Caching
• Self-healing resiliency – resilient system fabric to maximize uptime
• Breakthrough efficiencies – common and integrated experience with iLO3, Insight Control, and Thermal Logic

The HP OLTP RA is an enterprise-class scalable architecture optimized for Microsoft SQL Server 2008 R2. With the Non-Uniform Memory Access NUMA architecture, you have the ability to deploy SQL server instances or databases in NUMA nodes. Powered by SQL Server 2008 R2, the HP OLTP RA combines the advantage of multi-processor servers with query parallelism to bring Tier 1 SQL database features optimized for OLTP workloads. With sufficient CPU power to handle VLDB compression and large reindexing jobs, the HP ProLiant DL980 server is optimized specifically for SQL Server 2008 R2 and yet will be able to take advantage of SQL
Server 2012 features when available.

How it compares to appliances?

image

Download Datasheet:

HP Enterprise Transaction Processing Reference