Architecture
|
» |
HP recommended configurations for online transaction processing: ProLiant DL980 G7, VMA-series Memory Array (VMA) and Universal DB SuperSystem |
Updated: 2012-02-08
Reviewed: 2012-02-08
|
| |
|
This reference architecture uses HP DL980 G7 servers with HP VMA Memory Arrays to provide a high performance platform for the Universal DB SuperSystem OLTP workloads. When higher IOPS are required for performance, recommend this architecture.
|
|
» |
HP Configuration and Load Guide for Microsoft SQL Server 2008 R2 Fast Track Data Warehouse 3.0 |
Updated: 2012-01-16
Reviewed: 2012-01-16
|
| |
|
This white paper describes the process involved in building and loading a Microsoft SQL Server 2008 R2 Fast Track Data Warehouse on HP hardware. Step by step instructions as well as best practices are provided.
|
|
» |
High speed data export from an HP Enterprise Data Warehouse Appliance to an SMP Microsoft SQL Server
|
Updated: 2011-11-11
Reviewed: 2011-11-11
|
| |
|
This paper describes how to use the HP Enterprise Data Warehouse Appliance and Microsoft SQL Server Parallel Data Warehouse’s Remote Table Copy feature to export data to a data mart hub within a hub and spoke Business Intelligence architecture.
|
|
» |
Best Practices for HP Enterprise Data Warehouse Appliance/Microsoft SQL Server 2008 Parallel Data Warehouse R2
|
Updated: 2011-11-17
Reviewed: 2011-11-17
|
| |
|
This document is a guide to help you take advantage of the HP Enterprise Data Warehouse (EDW) Appliance’s capabilities. It discusses EDW and Microsoft SQL Server 2008 Parallel Data Warehouse R2 concepts and recommends various best practices.
|
|
» |
Reference Architecture: HP Database Consolidation Solution for Microsoft SQL Server 2008 R2
|
Updated: 2011-06-22
Reviewed: 2011-06-22
|
| |
|
The HP Database Consolidation Solution is a reference architecture designed for consolidating hundreds of SQL servers. Preconfigured and prebuilt in HP factories and optionally installed onsite by HP Services to ease installation.
|
|
» |
HP Enterprise Data Warehouse Appliance architecture overview and performance guide |
Updated: 2011-07-06
Reviewed: 2011-07-06 |
| |
|
This paper will provide the reader with an in-depth view of the HP Enterprise Data Warehouse (EDW) Appliance which has been optimized to support the Microsoft SQL Server Parallel Data Warehouse (PDW) software. Performance metrics are also discussed.
|
|
» |
Microsoft SQL Server 2008 Fast Track: HP StorageWorks P2000 G3 MSA Multipath I/O configuration and best practices |
Updated: 2010-11-24
Reviewed: 2010-11-24 |
| |
|
This paper describes a process to create and execute a manual path mapping process for HP P2000 G3 MSA arrays in a Microsoft SQL Server Fast Track environment.
|
| |
» |
HP BladeSystem Matrix infrastructure orchestration template – SQL Server 2008 OLTP Enterprise configuration |
Updated: 2009-11-23
Reviewed: 2009-11-23 |
| |
|
This paper provides the details for a Microsoft SQL Server OLTP template for an HP BladeSystem Matrix infrastructure. The template is designed to provision the server, storage, and network resources necessary to support an OLTP workload.
|
| |
» |
Business Intelligence – HP BladeSystem c7000 reference configurations and best practices for Microsoft SQL Server 2008 |
Updated: 2009-08-04
Reviewed: 2009-08-04 |
| |
|
This document presents some best practices and reference configurations for deploying Microsoft SQL Server 2008 based Business Intelligence solutions on the HP BladeSystem c7000 enclosure.
|
| Benchmarks and performance |
» |
Performance characterization for HP ProLiant DL980 G7 and Microsoft Windows Server 2008 R2 Hyper-V |
Updated: 2011-04-19
Reviewed: 2011-04-19 |
| |
|
This report presents a performance characterization for an HP ProLiant DL980 G7 server with Microsoft Windows Server 2008 R2 Hyper-V. VMs on the DL980 represent consolidated servers and have SQL Server 2008 SP1 running under a generic OLTP workload.
|
|
» |
Performance brief for HP Business Decision Appliance |
Updated: 2011-02-02
Reviewed: 2010-02-02 |
| |
|
The HP Business Decision Appliance was designed to simplify the installation, configuration and management of PowerPivot for SharePoint. HP engineers examine the performance of the HP BDA to provide a baseline expectation.
|
| |
» |
Improving database consolidation efficiency using the HP ProLiant DL385 G7 server with low voltage DDR3 memory and Solid State Drives |
Updated: 2010-11-09
Reviewed: 2010-11-09 |
| |
|
This white paper describes a demo highlighting the benefits of solid state drives and low voltage DDR3 memory when running a Microsoft SQL Server database workload in a VMware vSphere virtualized environment.
|
| |
» |
Backup and restore best practices for an Enterprise SQL Server 2008 Data Warehouse: HP XP24000 storage, ProLiant DL785 server and Symantec NetBackup |
Updated: 2010-01-07
Reviewed: 2010-01-07 |
| |
|
This paper discusses the backup-recovery of an enterprise class data warehouse using various backup and recovery methodologies. It describes a configuration using HP storage and servers to backup a SQL Server database using Symantec NetBackup.
|
| |
» |
Best practices for deploying Microsoft SQL Server 2008 tools on HP Integrity rx8640 and Superdome servers |
Updated: 2009-06-04
Reviewed: 2009-06-04 |
| |
|
This white paper demonstrates the capabilities of HP Integrity rx8640 and Superdome servers utilizing Microsoft SQL Server 2005/2008 and SQL Server BI tools namely SQL Server Integration Services, Analysis Services, and Reporting Services.
|
| |
» |
Best practices for Microsoft SQL Server 2005 on HP Integrity Superdome servers for Very Large Database (VLDB) BI solutions |
Updated: 2006-12-14
Reviewed: 2006-12-14 |
| |
|
Databases are at the heart of a number of trends in IT. The HP Integrity server family, with Windows 2003 and SQL 2005 (64-bit), offers an excellent approach to scaling up and consolidating database environments.
|
| |
» |
Best practices for highly available HP Integrity servers and Microsoft SQL Server |
Updated: 2007-07-09
Reviewed: 2007-07-09 |
| |
|
Business Intelligence solutions are increasingly becoming mission critical implementations. Combing Microsoft's "Always On" technologies and HP Integrity servers is the ideal way to create this infrastructure
|
| High availability
|
» |
Microsoft SQL Server 2008 Fast Track: A Multi-Site Disaster Recovery Architecture using the HP P2000 G3 MSA Storage Array
|
Updated: 2012-01-05
Reviewed: 2012-01-05
|
| |
|
This paper describes a Disaster Recovery manual failover process for Microsoft SQL Server Fast Track using PowerShell scripting coupled with the remote snapshot capability of the HP P2000 G3 Modular Smart Array Systems.
|
| Installation |
» |
Installing and operating HP PolyServe for Microsoft SQL Server for SAP databases |
Updated: 2007-12-05
Reviewed: 2007-12-05 |
| |
|
HP PolyServe software consolidates servers and storage into manageable, available and scalable utilities for database and file serving. Introducing HP PolyServe's approach to virtualization for mission-critical applications like SAP extend the benefits of consolidation to this critical business application.
|
| Performance and scalability |
» |
Improving scalability and storage performance with HP StorageWorks EVA8400 and Microsoft Windows Server 2008 R2 |
Updated: 2009-12-02
Reviewed: 2009-12-02 |
| |
|
This technical brief provides details on the hardware and software solution, the testing configuration, and results demonstrating a 33% improvement in CPU usage when comparing Windows Server 2008 R2 to Windows Server 2008 running on ProLiant DL585.
|
| |
» |
Performance guide for Microsoft SQL Server 2008 Fast Track Data Warehouse on HP ProLiant DL385 |
Updated: 2009-11-18
Reviewed: 2009-11-18 |
| |
|
This paper describes performance and best practices for using an HP ProLiant DL385 based Microsoft SQL Server Fast Track data warehouse. It describes performance results with several variants of quad and six-core processors using MSA2000 storage.
|
| |
» |
Microsoft SQL Server 2008 performance tuning on HP Integrity and ProLiant servers |
Updated: 2009-05-25
Reviewed: 2009-05-25 |
| |
|
This paper explores some performance tuning techniques that enable Microsoft SQL Server 2008 scalability on a wide spectrum of HP servers, namely on high end ProLiant servers running x64 architectures and HP Integrity servers.
|
| Sizing & Configuration |
» |
HP 95TB reference configuration for Microsoft SQL Server 2008 R2 Fast Track Data Warehouse 3.0: HP ProLiant DL980 G7 and P2000 G3 MSA
|
Updated: 2012-02-07
Reviewed: 2012-02-07 |
| |
|
This paper describes a 95TB Microsoft SQL Server 2008 R2 Fast Track reference configuration using the HP ProLiant DL980 G7 server and HP P2000 G3 MSA storage.
|
|
» |
HP reference configurations for Microsoft SQL Server 2008 Fast Track Data Warehouse 3.0: HP ProLiant DL380 G7 and P2000 G3 MSA |
Updated: 2011-03-08
Reviewed: 2011-03-08 |
| |
|
This paper details a Microsoft SQL Server 2008 Fast Track reference configuration based on the HP ProLiant DL380 G7 server connected to HP P2000 G3 MSA storage.
|
|
» |
HP reference configurations for Microsoft SQL Server 2008 Fast Track Data Warehouse 3.0: HP ProLiant DL385 G7 and P2000 G3 MSA |
Updated: 2011-03-08
Reviewed: 2011-03-08 |
| |
|
This paper details a Microsoft SQL Server 2008 Fast Track reference configuration using an HP ProLiant DL385 G7 server with HP P2000 G3 MSA storage.
|
| |
» |
HP 60TB reference configuration for Microsoft SQL Server 2008 R2 Fast Track Data Warehouse 3.0: HP ProLiant DL580 G7 and P2000 G3 MSA |
Updated: 2011-11-11
Reviewed: 2011-11-11 |
| |
|
This paper describes a 60TB Fast Track Data Warehouse 3.0 configuration featuring the HP ProLiant DL580 G7 server with Westmere-EX processors and HP P2000 G3 MSA storage arrays.
|
| |
» |
HP reference configurations for Microsoft SQL Server 2008 Fast Track Data Warehouse 3.0: HP ProLiant DL585 G7 and P2000 G3 MSA |
Updated: 2011-03-08
Reviewed: 2011-03-08 |
| |
|
This paper describes a 20/40TB Microsoft SQL Server 2008 Fast Track reference configuration using the HP ProLiant DL585 G7 server and HP P2000 G3 MSA storage.
|
| |
» |
HP reference configurations for Microsoft SQL Server 2008 Fast Track Data Warehouse 3.0: HP ProLiant DL370 G6 with direct attached storage |
Updated: 2011-03-07
Reviewed: 2011-03-07 |
| |
|
This paper details a Microsoft SQL Server 2008 Fast Track reference configuration based on the HP ProLiant DL370 G6 server using direct attached storage to provide an entry level architecture.
|
| |
» |
HP recommended configurations for online transaction processing: ProLiant DL980 G7 and Microsoft SQL Server 2008 R2 |
Updated: 2010-06-21
Reviewed: 2010-06-21 |
| |
|
This white paper describes two recommended configurations to support large online transaction processing (OLTP) solutions, capitalizing on the power of the new HP ProLiant DL980 G7 server and Microsoft SQL Server 2008 R2.
|
| |
» |
HP Sizer for Microsoft SQL Server Fast Track Data Warehouse |
Updated: 2010-06-04
Reviewed: 2010-06-04 |
| |
|
An automated tool that helps you determine the appropriate Fast Track data warehouse hardware configuration for your environment. Provides a prescriptive approach for balancing server, storage, network and software configurations for architecting Microsoft SQL Server 2008 data warehouse solutions.
|
| |
» |
Business Intelligence - HP ProLiant server reference configurations for Microsoft SQL Server 2008 |
Updated: 2009-12-11
Reviewed: 2009-12-11 |
| |
|
This paper discusses business intelligence reference configurations for Microsoft SQL Server 2008 on HP ProLiant servers, for ETL, ROLAP and OLAP cube tiers, based on lab, customer, and Industry standard benchmarks, as well as HP's experience.
|
| |
» |
Business Intelligence - HP Integrity server reference configurations for Microsoft SQL Server 2008 |
Updated: 2009-12-08
Reviewed: 2009-12-08 |
| |
|
This paper discusses business intelligence reference configurations for Microsoft SQL Server 2008 on HP Integrity servers, for ETL, ROLAP and OLAP cube tiers, based on lab, customer, and Industry standard benchmarks, as well as HP's experience.
|
| |
» |
HP reference configuration for SQL Server 2008 Fast Track Data Warehouse: ProLiant DL380 G6 and StorageWorks MSA2000fc |
Updated: 2009-11-12
Reviewed: 2009-11-12 |
| |
|
This paper depicts an Intel based reference configuration for Microsoft SQL Server 2008 Fast Track Data Warehouse utilizing the HP ProLiant DL380 G6 and HP StorageWorks 2000fc Modular Smart Array storage.
|
| |
» |
HP reference configuration for SQL Server 2008 Fast Track Data Warehouse: ProLiant DL580 and StorageWorks MSA2000fc |
Updated: 2009-11-12
Reviewed: 2009-11-12 |
| |
|
This paper depicts an Intel based reference configuration for Microsoft SQL Server 2008 Fast Track Data Warehouse utilizing the HP ProLiant DL580 G5 and HP StorageWorks 2000fc Modular Smart Array storage.
|
| |
» |
HP reference configuration for SQL Server 2008 Fast Track Data Warehouse: ProLiant DL385 and StorageWorks MSA2000fc |
Updated: 2009-10-15
Reviewed: 2009-10-15 |
| |
|
Microsoft SQL Server Fast Track Data Warehouse for HP servers, storage and network products provides a prescriptive approach for balancing server, storage, network and software configurations for architecting SQL Server 2008 data warehouse solutions.
|
| |
» |
HP reference configuration for SQL Server 2008 Fast Track Data Warehouse: ProLiant DL785 and StorageWorks MSA2000fc |
Updated: 2009-10-14
Reviewed: 2009-10-14 |
| |
|
Microsoft SQL Server Fast Track Data Warehouse for HP servers, storage and network products provides a prescriptive approach for balancing server, storage, network and software configurations for architecting SQL Server 2008 data warehouse solutions.
|
| |
» |
HP reference configuration for SQL Server 2008 Fast Track Data Warehouse: ProLiant DL585 and StorageWorks MSA2000fc |
Updated: 2009-10-14
Reviewed: 2009-10-14 |
| |
|
Microsoft SQL Server Fast Track Data Warehouse for HP servers, storage and network products provides a prescriptive approach for balancing server, storage, network and software configurations for architecting SQL Server 2008 data warehouse solutions.
|
| |
» |
OLTP reference configuration guidelines for Microsoft SQL Server 2008 on HP ProLiant servers |
Updated: 2009-09-09
Reviewed: 2009-09-09 |
| |
|
This white paper describes a range of reference configurations to support small to large online transaction processing (OLTP) solutions, capitalizing on the scalable power of HP ProLiant x64 systems and Microsoft SQL Server 2008 (x64).
|
| |
» |
OLTP reference configuration guidelines for Microsoft SQL Server 2008 on HP Integrity servers |
Updated: 2009-09-04
Reviewed: 2009-09-04 |
| |
|
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 2008 (64-bit).
|
| |
» |
HP Insight Orchestration template for HP BladeSystem Matrix - SQL Server 2008 Business Intelligence Enterprise configuration |
Updated: 2009-06-24
Reviewed: 2009-06-24 |
| |
|
This document provides the details for a Microsoft SQL Server 2008 Business Intelligence template for HP Insight Orchestration.
|
| |
» |
Business Intelligence - HP DL785 G5 server reference configurations for Microsoft SQL Server 2008 |
Updated: 2009-06-03
Reviewed: 2009-06-03 |
| |
|
The document discusses business intelligence reference configurations for Microsoft SQL Server 2008 running on HP ProLiant DL785 G5 servers and HP StorageWorks storage, including ETL, ROLAP and OLAP cube tiers for typical BI environments.
|
| |
» |
Business Intelligence – HP Integrity server reference configurations for Microsoft SQL Server 2008 |
Updated: 2008-09-19
Reviewed: 2008-09-19 |
| |
|
This paper discusses business intelligence reference configurations for Microsoft SQL Server 2008 on HP Integrity servers, for ETL, ROLAP and OLAP cube tiers, based on lab, customer, and Industry standard benchmarks, as well as HP's experience.
|
| |
» |
HP ProLiant Server Transaction Processing Sizer for Microsoft SQL Server 2005/2008 (x64) |
Updated: 2008-04-09
Reviewed: 2008-04-09 |
| |
|
The HP ProLiant server transaction processing sizer for Microsoft SQL Server 2005 is an automated tool which helps you determine an optimum hardware configuration for your database server used in a transaction environment based on your requirements. This sizer for Microsoft SQL Server supports the HP ProLiant server family and appropriate options.
|
| |
» |
HP Business Intelligence Sizer for Microsoft SQL Server 2005/2008 |
Updated: 2008-04-09
Reviewed: 2008-04-09 |
| |
|
The HP Business Intelligence Sizer for Microsoft SQL Server 2005/2008 is an automated tool that helps you determine the appropriate hardware configuration for your database server used in a data warehousing ROLAP (Relational Online Analytical Processing) environment. In addition this tool will also size the ETL (Extract, Transformation, and Load) layer using SQL Server 2005 Integration Services. |
Printable version
