• Introduces "Half-Rack" as a new choice of racks, which contains 5 DL360s, 4 P2000s with Infiniband, Fibre Channel, and Ethernet infrastructure

HP Enterprise Data Warehouse Appliance, optimized for SQL Server 2008 R2 Parallel Data Warehouse, is a dedicated data warehouse appliance offering massive parallel scale-out query processing, allows users to scale up to much higher levels of performance and capacity than single SMP systems can offer. HP and Microsoft have engineered this joint offering based on multiple HP ProLiant servers (working in parallel through an MPP software layer to function as a single entity), MSA P2000 G3 arrays, high-speed, low-latency interconnects, Microsoft SQL Server 2008 R2 Parallel Data Warehouse software, and HP and Microsoft services and support HP Enterprise Data Warehouse lets you scale out data warehouse solutions into the hundreds of terabytes of data for the most demanding business needs. Queries run against tables containing trillions of rows of data are returned in seconds, providing new levels of scalability and performance for large enterprises. The newly released batch feature makes your maintenance work easier than ever. HP Enterprise Data Warehouse Appliances have one control rack and one to four data racks. Through the use of massively parallel technology, HP's dense servers and storage subsystems, we are able to achieve outstanding performance.

HP Enterprise Data Warehouse Appliances are fully integrated and tested. The HP solution contains one control rack and from one to four data racks, each containing ten active compute nodes and one passive standby node. The shared-nothing software architecture is tightly coupled to the hardware solution, pre-installed and optimized to achieve balanced throughput, I/O and processing power. User choices within the pre-configured appliance are minimal; The fine tuned configuration allows customers to choose size and form factor of disks in the data racks and back up, PDU type, and additional services. Clients purchasing the Enterprise Data Warehouse Appliance may also purchase a single rack test/development system to allow them to test for future implementations.

The HP Enterprise Data Warehouse Appliance control rack contains multiple HP ProLiant DL300 series servers and HP MSA P2000 G3 storage. The functions within the control rack include:

• Management Nodes (active/passive cluster), which acts internally as the domain controller for all the servers in the HP Enterprise Data Warehouse Appliance and provides the interface for DBAs or data center operations to access and manage the overall solution.
• A Landing Zone server, where cleansed data is stored before loading data into the data warehouse. The Landing Zone server also includes a DVD drive, in the event that software needs to be loaded into the environment.
• The Control Nodes (active/passive cluster) within the control rack accepts queries from users, and creates an MPP execution plan which instructs one or more compute nodes to execute some portion of the query, often in parallel. Some queries will enter directly, such as from Microsoft Excel 2010 or Microsoft SQL Server PowerPivot for Microsoft Excel, while others may go through an application tier or OLAP cube such as SQL Server Analysis Services.
• A Backup Node and the appropriate associated storage. The determination of appropriate backup storage is determined by the customer's disk choice and number of data racks ordered. HP and Microsoft have worked together to optimize the backup.

The Enterprise Data Warehouse Appliance data racks are where the physical data warehouse or data mart is stored. Two types of tables are leveraged: replicated tables with copies stored on every node and distributed tables where separate physical tables on multiple compute nodes are logically joined through metadata stored on the control node. Tables are stored on the compute nodes, with the data stored on each node's MSA P2000 G3 arrays. By balancing the data across compute nodes and storing different table types appropriately (small dimension tables are replicated; very large fact or transaction tables with billions or even trillions of rows are distributed), the HP Enterprise Data Warehouse Appliance is able to access the data in parallel and achieve high levels of I/O throughput. The massively parallel architecture gives our solution the speed to provide user queries with significantly higher levels of I/O throughput than may be achieved on a scale up SMP system. Customers may choose disk size, form factor (LFF or SFF disks), and PDU type (single phase or triple phase for redundancy).

The newly released "Half-Rack" EDW provide a lowered priced entry point to customers whose data requirements are modest to start with and will grow over time. The half-rack EDW has a normal control rack and half a data rack which contains 5 DL360s, 4 P2000s with Infiniband, Fibre Channel, and Ethernet infrastructure. The choice of disks in the half-rack EDW remains the same as full-size EDW: 300 GB Large Form Factor (LFF), 300 GB Small Form Factor (SFF), 600 GB SFF, and 1 TB LFF. Currently, maximum of 1 half-rack EDW can be ordered.

For more information about the HP Enterprise Data Warehouse Appliance see: http://www.hp.com/solutions/microsoft/edw
For more information about HP ProLiant servers see: http://h18004.www1.hp.com/products/servers/platforms
For more information about HP Insight software, see: http://www.hp.com/go/insight
For more information about Storage products, see: www.hp.com/go/storage
For more information about HP Racks see: http://h18004.www1.hp.com/products/servers/proliantstorage/racks/index.html
For more information about the HP and Microsoft partnership see: http://h71028.www7.hp.com/enterprise/cache/8161-0-0-0-121.html
For information about HP services see: www.hp.com/services/microsoft

The method for purchasing the HP Enterprise Data Warehouse Appliance is simple. Start by ordering one control rack and one to four data racks.

NOTE: Please check with Microsoft for availability of Microsoft SQL Server 2008 R2 Parallel Data Warehouse software.
NOTE: At initial installation, data rack(s) must be ordered with a control rack. If you wish to add a data rack to an existing HP Enterprise Data Warehouse Appliance installation, please contact your sales or services representative. HP will work jointly with Microsoft to assist as you add data racks, up to a maximum of four.
NOTE: All data racks purchased must be co-located, side by side, with the control rack to which they are connected.
NOTE: For detailed ordering information please see the Configuration Information section of this QuickSpecs.
NOTE: With all HP Enterprise Data Warehouse Appliance control rack and data rack orders, the following services are included:

• Factory services to default configure, rack, and cable the infrastructure in a rack,
• Site assessment,
• Installation and start up services,
• 3yr Support Plus 24 (24x7 hardware and software support with 4 hour on-site hardware response), with the option to upgrade to higher service levels or extend to longer durations.

While HP is building the Enterprise Data Warehouse Appliance for a given customer, an assigned project manager from Technology Services will start managing a team of Technical Support (TS) engineers to begin planning the rollout of the implementation service, including engaging with the customer on environmental requirements and related details. TS engineers will start the actual implementation of the equipment as soon as possible after its arrival date at the customer site.

The Technology Services Enterprise Data Warehouse Appliance Implementation Service is detailed in the implementation section below.

The onsite Implementation and Startup Service consists of these steps::

• Prior to solution delivery, a simplified site readiness assessment will be performed to ensure that the customer has enough power, cooling, floor space to accommodate the Enterprise Data Warehouse Appliance requirements
• Upon delivery to customers site, unpack and inspect for damages
• Integrate racks in to customers environment, power, network cabling
• Racks interconnect cabling
• Configuration of the network connections towards the customer environment and connection verification
• Install and configure HP Insight Remote Support (if applicable)
• Conduct basic appliance level functionality testing using the provided "Sanity" tool. .Familiarize customer with the equipment and with basic processes (HP-side only)
• Instruct customer on how to place support calls

In addition to the Enterprise Data Warehouse Appliance Implementation Service, HP highly recommends HP Education Services (for customer training and education) and additional Technical Services, as well as in-depth installation or implementation services as may be needed.

For additional information please visit:

HP Education Services: www.hp.com/learn/proliant
Technical Services: www.hp.com/services/technicalservices
Deployment Services: www.hp.com/services/deployment

Rack 10000 G2 series cabinets
The increasing power of new high-performance processor technology requires increased cooling efficiency for rack-mounted servers. The HP 10000 G2 Series racks provide enhanced airflow for maximum cooling, allowing these racks to be fully loaded with servers using the latest processors.

• Front and rear doors: If your 42U server rack includes closing front and rear doors, you must allow 830 square inches (5,350 sq cm) of holes evenly distributed from top to bottom to permit adequate airflow (equivalent to a required 64 percent open area for ventilation).
• The clearance from face of rack to inside of the front door needs to be a minimum of 1.75".
• Side: The clearance between the installed rack component and the side panels of the rack needs to be a minimum of 2.75 inches (7 cm).

The Enterprise Data Warehouse Appliance Control Rack configuration includes the following:

One (1) HP Universal Rack 10642 G2 Shock Rack includes:

• Two (2) Control nodes each includes:
  • One (1) HP ProLiant DL380 G7 Server (2x X5690) includes:
    • Twelve (12) HP 8GB (1x8GB) Dual Rank x4 PC3-10600 (DDR3-1333) Registered CAS-9 Memory Kit
    • Fourteen (14) HP 300GB 6G SAS 10K rpm SFF (2.5-inch) Dual Port Enterprise Hard Drive
• One (1) Control node shared storage:
• One (1) HP P2000 G3 FC MSA Dual Controller LFF Modular Smart Array System includes:
  • Five (5) HP P2000 450GB 6G SAS 15K LFF (3.5 inch) DP ENT HDD
• Two (2) Management server nodes each includes:
• One (1) HP ProLiant DL360 G7 (2x E5620) Server includes:
  • Nine (9) HP 4GB (1x4GB) Dual Rank x4 PC3-10600 (DDR3-1333) Registered CAS-9 Memory Kit
  • Two (2) HP 300GB 6G SAS 10K rpm SFF (2.5-inch) Dual Port Enterprise Hard Drive
• One (1) Landing zone server includes:
• One (1) HP ProLiant DL370 G6 (2x X5690) includes:
• Six (6) HP 2GB (1x2GB) Dual Rank x8 PC3-10600 (DDR3-1333) Registered CAS-9 Memory Kit
• Six (6) HP 4GB (1x4GB) Dual Rank x4 PC3-10600 (DDR3-1333) Registered CAS-9 Memory Kit
• Ten (10) HP 2TB 6G SAS 7.2K rpm LFF (3.5-inch) Dual Port Midline Hard Drive
• Two (2) HP 300GB 6G SAS 15K rpm LFF (3.5-inch) Enterprise Hard Drive
• One (1) Backup Server includes:
• One (1) HP ProLiant DL380 G7 (2x E5620) includes:
  • Two (2) Intel® Xeon® Processor E5620
  • Twenty-four 24GB (6 x 4GB) PC3-10600R (DDR3-1333) Registered DIMMs
• Two (2) HP 8/8 (8) ports Enabled SAN Switch
• Two (2) HP Switch 2810-24G
• Two(2) InfiniBand IB 4X QDR 36P Managed Switch
• Choice of triple phase or single phase Modular Power Distribution Unit
  • HP 40A 3 Phase Core Only Intelligent Modular Power Distribution Unit (PN AF533A).
  • HP 24A Core Only Intelligent Modular Power Distribution Unit (PN AF520A).
• Microsoft Windows Server 2008 R1 Enterprise Edition on each node
• HP iLO Advanced 1-Server including 1 yr 24x7 software support
• SQL Server 2008 Parallel Data Warehouse Edition
• Microsoft SQL Server 2008 R2 Parallel Data Warehouse software is preinstalled
• Factory services to default configure, rack, and cable the infrastructure in a rack
• Site assessment
• Installation and start up
• 3yr HP Support Plus 24 (or upgrade to higher service level)

NOTE: A backup server with appropriate storage will be included with the control rack. The amount of backup storage included is based upon disk choice and quantity of data racks purchased See the backup storage details below.
NOTE: The SQL Server 2008 R2 Parallel Data Warehouse software is preinstalled and preconfigured but licenses must be purchased separately.
NOTE: Support for the Microsoft software must be purchased from Microsoft.

HP Enterprise Data Warehouse Appliance Data Rack

The Enterprise Data Warehouse Appliance Data Rack configuration includes the following:

One (1) HP Universal Rack 10642 G2 Shock Rack includes:

• Eleven (11) Data Nodes each includes:
  • One (1) HP ProLiant DL 360 G7 (2x X5670) Server includes:
    • Twelve (12) HP 8GB 2x4 PC3-10600R-9
    • Eight (8) HP 600GB 6G SAS 10K 2.5in DP ENT HDD
• Ten (10) Data Node Storage- choose from the following options:
  • Option 1:
    • One (1) HP P2000 G3 FC MSA Dual Controller LFF Modular Smart Array System
      • Eleven (11) HP P2000 300GB 6G SAS 15K LFF (3.5 inch) DP ENT HDD
• Option 2:
  • One (1) HP P2000 G3 MSA FC Dual Controller SFF Modular Smart Array System
    • Twenty-four (24) HP 300GB 6G SAS 10K SFF (2.5 inch) DP ENT HDD
• Option 3:
  • One (1) HP P2000 G3 MSA FC Dual Controller LFF Modular Smart Array System
    • Eleven (11) HP P2000 1TB 6G SAS 7.2K LFF (3.5 inch) DP MDL HDD
• Option 4:
• One (1) HP P2000 G3 MSA FC Dual Controller SFF Modular Smart Array System
• Twenty-four (24) HP P2000 600GB 6G SAS 10K SFF (2.5 inch) DP ENT HDD
• Two (2) HP Switch 2810-48G
• Two (2) InfiniBand IB 4X QDR 36P Managed Switch
• Two (2) HP 8/40 SAN Switch (24 ports enabled)
• Choice of triple phase or single phase Modular Power Distribution Unit (PDU)
  • HP 40A 3 Phase NA/JP Core Only Intelligent Modular Power Distribution Unit (PN AF533A).
  • HP 24A NA/JP Core Only Intelligent Modular Power Distribution Unit (PN AF520A).
  • HP 32A 3 Phase Intl Intelligent Modular Power Distribution Unit (PN AF527A).
  • HP 32A Intl Core Only Intelligent Modular Power Distribution Unit (PN AF525A)
• Microsoft Windows Server 2008 R1 Enterprise Edition
• SQL Server 2008 R2 Parallel Data Warehouse
• Factory services to default configure, rack, and cable the infrastructure in a rack
• Site Assessment
• Installation and Start Up Service
• 3 year HP Support Plus 24 (or upgrade to higher service level)

HP Enterprise Data Warehouse Appliance "Half-Rack" Data Rack

NOTE: maximum of 1 half-rack EDW can be ordered.

One (1) HP Universal Rack 10642 G2 Shock Rack includes:

• Five (5) Data Nodes each includes:
  
  • One (1) HP ProLiant DL 360 G7 (2x X5670) Server includes:
    
    • Twelve (12) HP 8GB 2x4 PC3-10600R-9
      
    • Eight (8) HP 600GB 6G SAS 10K 2.5in DP ENT HDD
      
• Four (4) Data Node Storage- choose from the following options:
  
  • Option 1:
    
    • One (1) HP P2000 G3 FC MSA Dual Controller LFF Modular Smart Array System
      
      • Eleven (11) HP P2000 300GB 6G SAS 15K LFF (3.5 inch) DP ENT HDD
        
  • Option 2:
    
    • One (1) HP P2000 G3 MSA FC Dual Controller SFF Modular Smart Array System
      
      • Twenty-four (24) HP 300GB 6G SAS 10K SFF (2.5 inch) DP ENT HDD
        
  • Option 3:
    
    • One (1) HP P2000 G3 MSA FC Dual Controller LFF Modular Smart Array System
      
      • Eleven (11) HP P2000 1TB 6G SAS 7.2K LFF (3.5 inch) DP MDL HDD
        
  • Option 4:
    
    • One (1) HP P2000 G3 MSA FC Dual Controller SFF Modular Smart Array System
      
      • Twenty-four (24) HP P2000 600GB 6G SAS 10K SFF (2.5 inch) DP ENT HDD
        
  • Two (2) HP Switch 2810-48G
    
  • Two (2) InfiniBand IB 4X QDR 36P Managed Switch
    
  • Two (2) HP 8/40 SAN Switch (24 ports enabled)
    
  • Choice of triple phase or single phase Modular Power Distribution Unit (PDU)
    
    • HP 40A 3 Phase NA/JP Core Only Intelligent Modular Power Distribution Unit (PN AF533A).
      
    • HP 24A NA/JP Core Only Intelligent Modular Power Distribution Unit (PN AF520A).
      
    • HP 32A 3 Phase Intl Intelligent Modular Power Distribution Unit (PN AF527A).
      
    • HP 32A Intl Core Only Intelligent Modular Power Distribution Unit (PN AF525A)
      
  • Microsoft Windows Server 2008 R1 Enterprise Edition
    
  • SQL Server 2008 R2 Parallel Data Warehouse
    
  • Factory services to default configure, rack, and cable the infrastructure in
  • rack
    
  • Site Assessment
    
  • Installation and Start Up Service
    
  • 3 year HP Support Plus 24 (or upgrade to higher service level)
    

  NOTE: The SQL Server 2008 R2 Parallel Data Warehouse software is preinstalled and preconfigured. Licenses must be purchased separately.
  NOTE: Support for the Microsoft software must be purchased from Microsoft.
  NOTE: PDU redundancy on Data Racks are offered as default feature.
  NOTE: The same storage option will be applied to all data racks ordered. Each data rack must have the same configuration to ensure the appropriate backup node configuration is included in the control rack
  

HP Enterprise Data Warehouse Appliance Test Development System

HP Enterprise Data Warehouse Appliance Test and Development System configuration includes:

One (1) HP Universal Rack 10642 G2 Shock Rack includes:

• Two (2) Data Nodes each includes:
  • One (1) HP ProLiant DL360 G7 (2x X5670) Server includes:
    • Twelve (12) HP 8GB (1x8GB) Dual Rank x4 PC3-10600 (DDR3-1333) Registered CAS-9 Memory Kit
    • Eight (8) HP 600GB 6G SAS 10K rpm SFF (2.5-inch) Dual Port Enterprise Hard Drive
• Two (2) Data Node Storage:
  • One (1) HP P2000 G3 FC MSA Dual Controller LFF Modular Smart Array System
    • Eleven (11) HP P2000 1TB 6G SAS 7.2K LFF (3.5 inch) DP MDL HDD
• One (1) Control Node Server includes:
• One (1) HP ProLiant DL380 G7 (2x X5690) Server includes:
  • Twelve (12) HP 8GB (1x8GB) Dual Rank x4 PC3-10600 (DDR3-1333) Registered CAS-9 Memory Kit
  • Fourteen (14) HP 300GB 6G SAS 10K rpm SFF (2.5-inch) Dual Port Enterprise Hard Drive
• One (1) Management Server includes:
• One (1) HP ProLiant DL360 G7 (2x E5620) Server includes:
  • Nine (9) HP 4GB (1x4GB) Dual Rank x4 PC3-10600 (DDR3-1333) Registered CAS-9 Memory Kit
  • Two (2) HP 300GB 6G SAS 10K rpm SFF (2.5-inch) Dual Port Enterprise Hard Drive
• One (1) Landing Zone Server includes:
• One (1) HP ProLiant DL370 (G6) (2x X5690) Server includes:
  • Six (6) HP 2GB (1x2GB) Dual Rank x8 PC3-10600 (DDR3-1333) Registered CAS-9 Memory Kit
  • Two (2) HP 300GB 6G SAS 15K rpm LFF (3.5-inch) Enterprise Hard Drive
  • Ten (10) HP 2TB 6G SAS 7.2K rpm LFF (3.5-inch) Dual Port Midline Hard Drive
• One (1) Backup Server includes:
• One (1) HP ProLiant DL370 (G6) (2x X5690) Server includes:
  • Six (6) HP 2GB (1x2GB) Dual Rank x8 PC3-10600 (DDR3-1333) Registered CAS-9 Memory Kit
  • Two (2) HP 300GB 6G SAS 15K rpm LFF (3.5-inch) Enterprise Hard Drive
  • Ten (10) HP 1TB 6G SAS 7.2K rpm LFF (3.5-inch) Dual Port Midline Hard Drive
• One (1) HP Switch 2810-48 G
• One (1) InfiniBand IB 4X QDR 36P Managed Switch
• Choice of triple phase or single phase Modular Power Distribution Unit (PDU)
  • HP 40A 3 Phase Core Only Intelligent Modular Power Distribution Unit (PN AF533A).
  • HP 24A Core Only Intelligent Modular Power Distribution Unit (PN AF520A).
• One (1) HP 8/8 SAN Switch 8GB 8-port
• Microsoft Windows Server 2008 Enterprise Edition
• SQL Server 2008 Parallel Data Warehouse Edition
• Site Assessment
• Installation and Start Up Service
• 3 year HP Support Plus 24 (or upgrade to higher service level)

NOTE: The management server and control node server are not active/passive.
NOTE: The SQL Server 2008 R2 Parallel Data Warehouse software is preinstalled and preconfigured. Licenses must be purchased separately.
NOTE: Support for the Microsoft software must be purchased from Microsoft.

HP 3yr Support Plus 24 is the required minimum support with Enterprise Data Warehouse Appliance and will be the included or default support selected.

To upgrade support levels, one of the following support offers may be selected:

HP Support Plus 24 - 4yr or 5yr

• For a higher return on your server and storage technology, our 3-year combined reactive support service delivers integrated onsite hardware/software support services available 24x7x365, including access to HP technical resources, 4-hour response onsite hardware support and software updates.

HP Proactive 24 Service - 3yr, 4yr or 5yr

• Provides improved stability, availability and operational effectiveness with an integrated hardware and software support service that combines industry-leading reactive technical assistance with proactive account services, giving your IT manage support from a team of service specialists.

HP Critical Service - 3yr, 4yr or 5yr

• Provides comprehensive proactive and reactive support designed for businesses that run essential mission-critical applications where downtime is not an option.
• NOTE: Each of these support levels include hardware and software reactive support and are available with DMR (defective media retention). Support for the Microsoft software has to be purchased separately from Microsoft.

Also, proactive services are available. HP Proactive Select can easily be added to the three-year, 24x7 hardware and software support that comes with your new HP Enterprise Data Warehouse Appliance.
Each HP Proactive Select package provides:

• An assigned account support manager focused on technical and operational improvements specific to your business environment
• Proactive service credits that can be redeemed for the service activities of your choice

Hewlett-Packard offers end-of-life HP product return, trade-in, and recycling programs in many geographic areas. For trade-in information, please go to: http://www.hp.com/go/green. To recycle your product, please go to: http://www.hp.com/go/green or contact your nearest HP sales office. Products returned to HP will be recycled, recovered or disposed of in a responsible manner.

The EU WEEE directive (2002/95/EC) requires manufacturers to provide treatment information for each product type for use by treatment facilities. This information (product disassembly instructions) is posted on the Hewlett Packard web site at: http://www.hp.com/go/green. These instructions may be used by recyclers and other WEEE treatment facilities as well as HP OEM customers who integrate and re-sell HP equipment.