| Architecture |
» |
HP Business Decision Reference Architecture: Using HP and Microsoft technology to bring BI to the masses |
Updated: 2013-04-29
Reviewed: 2013-04-29 |
| |
|
HP engineering has developed, tested, and offers this reference architecture for customers looking to deploy a self-service BI, using Microsoft Windows Server 2012, SharePoint 2013, and SQL Server 2012 built on top of the HP DL380p Gen8 server platform.
|
|
» |
HP 50 TB reference architectures for Microsoft SQL Server 2012 Fast Track Data Warehouse: HP ProLiant DL560 Gen8 and P2000 G3 MSA Storage |
Updated: 2013-03-29
Reviewed: 2013-03-29 |
| |
|
This paper describes a 50 TB Microsoft SQL Server Fast Track Data Warehouse configuration using the HP ProLiant DL560 Gen8 server and P2000 G3 MSA storage.
|
|
» |
Microsoft SQL Server Fast Track: HP P2000 G3 MSA Multipath I/O configuration and best practices |
Updated: 2013-03-19
Reviewed: 2013-03-19 |
| |
|
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 4/11 TB All Solid State reference architectures for Microsoft SQL Server 2012 Fast Track Data Warehouse: HP ProLiant DL380p Gen8 internal storage |
Updated: 2013-03-06
Reviewed: 2013-03-06
|
| |
|
This paper describes a 4/11 TB Microsoft Fast Track reference architecture featuring the HP ProLiant DL380p Gen8 and internal SATA SSD storage.
|
|
» |
HP 30TB reference architecture for Microsoft SQL Server 2012 Fast Track Data Warehouse 4.0 with Windows Server 2012 Server: HP ProLiant DL380p Gen8 and P2000 G3 MSA storage |
Updated: 2012-12-13
Reviewed: 2012-12-13
|
| |
|
This document provides specific details about the configuration and bill of materials for one such Fast Track 4.0 reference architecture, based on the HP ProLiant DL380p Gen8 server and the HP P2000 Modular Smart Array (P2000 G3 MSA) storage running on Windows Server 2012.
|
|
» |
HP reference architecture for Microsoft SQL Server 2008 Fast Track Data Warehouse 3.0: HP ProLiant DL385 G7 and P2000 G3 MSA |
Updated: 2012-11-29
Reviewed: 2012-11-29 |
| |
|
This paper describes a Microsoft SQL Server Fast Track 3.0 data warehouse reference architecture featuring the HP ProLiant DL385 G7 server with HP P2000 G3 MSA storage.
|
|
» |
HP reference architecture for Microsoft SQL Server 2008 Fast Track Data Warehouse 3.0: HP ProLiant DL585 G7 and P2000 G3 MSA |
Updated: 2012-11-29
Reviewed: 2012-11-29 |
| |
|
This paper describes a Microsoft SQL Server Fast Track 3.0 data warehouse reference architecture featuring the HP ProLiant DL585 G7 server and HP P2000 G3 MSA storage.
|
|
» |
HP 60TB reference architecture for Microsoft SQL Server 2012 Fast Track Data Warehouse: HP ProLiant DL580 G7 and P2000 G3 MSA storage
|
Updated: 2012-11-26
Reviewed: 2012-11-26
|
| |
|
This paper describes a 60TB configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse featuring the HP ProLiant DL580 G7 server and P2000 G3 storage.
|
|
» |
HP DBC Reference Architecture technical overview |
Updated: 2012-09-11
Reviewed: 2012-09-11
|
| |
|
The HP DBC Reference Architecture (DBC RA) is a reference architecture solution for database consolidation, provisioning, and running thousands of I/O demanding database workloads in a Microsoft private cloud model.
|
|
» |
HP 60TB reference architecture for Microsoft SQL Server 2008 R2 Fast Track Data Warehouse 3.0: HP ProLiant DL580 G7 and P2000 G3 MSA
|
Updated: 2012-08-28
Reviewed: 2012-08-28
|
| |
|
This paper describes a 60TB Microsoft SQL Server Fast Track Data Warehouse Reference Architecture featuring the HP ProLiant DL580 G7 server and HP P2000 G3 MSA storage.
|
|
» |
HP high availability solutions for Microsoft SQL Server Fast Track Data Warehouse using SQL Server 2012 failover clustering |
Updated: 2012-07-23
Reviewed: 2012-07-23 |
| |
|
This paper describes high availability solutions for HP Fast Track reference architectures using Microsoft SQL Server failover clustering.
|
|
» |
HP recommended configurations for online transaction processing: ProLiant DL980 G7, VMA-series Memory Array (VMA) and Universal DB Solution |
Updated: 2012-07-18
Reviewed: 2012-07-18 |
| |
|
This reference architecture uses HP DL980 G7 servers with HP VMA Memory Arrays to provide a high performance platform for the Universal DB Solution OLTP workloads. When higher IOPS are required for performance, recommend this architecture.
|
|
» |
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.
|
|
» |
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.
|
|
» |
HP 95TB reference architecture for Microsoft SQL Server 2008 R2 Fast Track Data Warehouse 3.0: HP ProLiant DL980 G7 and P2000 G3 MSA |
Updated: 2010-09-25
Reviewed: 2010-09-25 |
| |
|
This paper describes a 95TB Microsoft SQL Server Fast Track Data Warehouse reference architecture featuring the HP ProLiant DL980 G7 server and HP P2000 G3 MSA storage.
|
| |
» |
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.
|
| |
» |
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
|
| Best Practices |
» |
HP 3PAR StoreServ 7000 Storage for Microsoft SQL Server environments with VMware |
Updated: 2013-02-26
Reviewed: 2013-02-26 |
| |
|
HP 3PAR StoreServ offers an optimized storage solution that builds redundancy, performance, and breakthrough functionality on top of common components, driving a huge return on investment (ROI) as expected in a virtualized environment.
|
| High availability
|
» |
Universal Database Solution for Mission-Critical x86: HP ProLiant DL980 Microsoft SQL Server 2012 Edition
|
Updated: 2012-09-13
Reviewed: 2012-09-13 |
| |
|
This reference configuration is for an Ultra Performance and Highly Available SQL Server 2012 Database solution. Featuring the HP ProLiant DL980 server, HP VMA-Series Flash Memory Arrays and Microsoft SQL Server 2012 AlwaysOn Availability Groups.
|
|
|
» |
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.
|
| Management |
» |
Automated Tiering in Microsoft SQL Server Environments with HP 3PAR Arrays |
Updated: 2013-02-15
Reviewed: 2013-02-15 |
| |
|
This white paper describes how HP 3PAR AO addresses challenges in Microsoft SQL Server environments and how it can help deliver performance for less cost, while enabling administrators to provide differentiated service to multiple applications.
|
| 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.
|
| |
» |
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 3PAR StoreServ reference configuration for Microsoft SQL Server OLTP databases |
Updated: 2013-03-21
Reviewed: 2013-03-21
|
| |
|
This HP 3PAR StoreServ reference configuration white paper describes sizing, performance and best practice considerations for deployment of high performance enterprise Microsoft SQL Server 2012 OLTP databases on 3PAR StoreServ 10400 Storage.
|
|
» |
HP D2600 disk enclosure and HP Smart Array P411 2,000 user - 4 GB mailbox resiliency Exchange 2010 storage solution |
Updated: 2012-09-11
Reviewed: 2012-09-11
|
| |
|
This solution brief describes a tested configuration for deploying Microsoft Exchange Server 2010 (Exchange) in a 2,000 user mailbox resiliency environment with the HP D2600 disk enclosure and HP Smart Array P411 controller.
|
|
» |
HP 30TB reference architecture for Microsoft SQL Server 2008 R2 Fast Track Data Warehouse 3.0: HP ProLiant DL380p Gen8 and P2000 G3 MSA storage |
Updated: 2012-08-03
Reviewed: 2012-08-03
|
| |
|
This paper describes the properties of a 30TB Microsoft SQL Server 2008 R2 Fast Track Data Warehouse Reference Architecture using an HP ProLiant DL380p Gen8 server and P2000 G3 MSA storage arrays.
|
|
» |
HP Configuration and Load Guide for Microsoft SQL Fast Track Data Warehouse version 4
|
Updated: 2012-08-02
Reviewed: 2012-08-02
|
| |
|
This paper describes a process to configure and load a Microsoft SQL Server Fast Track 3.0 Reference Architecture on HP hardware from start to end.
|
| |
» |
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.
|
| |
» |
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.
|
Printable version
