HPE H6Y56A Product Data Sheet
QuickSpecs
HPE ConvergedSystem 300 for Microsoft Analytics Platform
Overview
Page 1
HPE ConvergedSystem 300 for Microsoft Analytics Platform
Base Rack - Front View
1.
HPE InfiniBand FDR 36 Port Switch (2): HPE ConvergedSystem 300 2.7 for MS APS IB Switch Kit
2. HPE Ethernet Switch 5900AF-48 G -4XG-2QSFP+ (2): HPE ConvergedSystem 300 2.0 for MS APS E Switch Kit
3. PDW Region - Orchestration & Failover Servers: HPE ConvergedSystem 300 2.7 for MS APS Passive Svr Kit (DL360 Gen10
server) (2)
4.
Optional: - Failover Server: HPE ConvergedSystem 300 2.7 for MS APS Passive Svr Kit (DL360 Gen10 server) (1)
5.
Optional: Data Scale Units: PDW Region
6. Optional: Data Scale Units: PDW Region
7.
Optional: Data Scale Units: PDW Region
8.
PDW Region Base Scale Unit: HPE ConvergedSystem 300 2.7 for MS APS PDW Svr Kit (HPE ProLiant DL360 Gen10 server) (2)
+ HPE ConvergedSystem 300 2.7 for MS APS Storage Kit (D6020) (1)
QuickSpecs
HPE ConvergedSystem 300 for Microsoft Analytics Platform
Overview
Page 2
What's New
• Updated with the newest HPE ProLiant DL360 Gen10 Servers, running on the Intel® Xeon® Scalabe Processor, to deliver
intensive environments providing
Updated with the newest HPE G2 Enterprise Series Rack(s) offering innovative physical security, structural integrity, cooling
At A Glance
HPE ConvergedSystem 300 for Microsoft Analytics Platform is a dedicated data warehouse appliance offering in-memory
solution starts with a single
servers
PDW Region Base Scale Unit (Required):
arallel and achieve high levels
Acts internally as the domain controller for all the servers in the
provides the interface for DBAs or data center operations to access and manage the overall solution.
industry-leading performance with versatile compute and security innovations.
• Now offering both a 2 TB and 4 TB disk options with the HPE D6020 enclosure = for data-
dense, cost-effective storage for massive data capacity applications, at low $/GB.
•
and cable management features.
• Updated HPE Support Pack Utility Suite, a unique set of tools designed to simplify and reduce the costs for operational
support and maintenance tasks. The Support Pack includes tools to run validation and diagnostics on the HPE
ConvergedSystem 300 for Microsoft Analytics Platform and help simplify updates and several other maintenance tasks.
• Updated with Microsoft Analytics Platform System 2016, Appliance Update 7, providing improved data
management, increased productivity and enhanced security.
column store , massive parallel scale-out query processing (MPP),, that allows users to scale up to much higher levels of
performance and capacity than single SMP systems can offer. HPE and Microsoft have engineered this joint offering
based on multiple HPE ProLiant servers (working in parallel through an MPP software layer to function as a single entity),
HPE ProLiant Servers, D6020 direct attach storage, high-speed, low-latency interconnects, SQL Server software
augmented with the MPP engine, and HPE and Microsoft services and support. HPE ConvergedSystem 300 for Microsoft
Analytics Platform lets you scale out data warehouse solutions to petabytes of data for the most demanding business
needs. Queries run against tables containing trillions of rows of data are return results in seconds, providing new levels of
scalability and performance for large enterprises. Through the use of massively parallel technology, HPE's dense servers
and storage subsystems, we are able to achieve outstanding performance.
HPE ConvergedSystem 300 for Microsoft Analytics Platforms are fully integrated and tested. The HPE
rack, each containing up a minimum of two active compute nodes, and orchestration and passive nodes, expandable to eight
active compute nodes. With expansion racks, the solution can extend to a maximum of 64 nodes. The shared-nothing software
architecture is 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.
The HPE ConvergedSystem 300 for Microsoft Analytics Platform base rack contains multiple HPE ProLiant DL360 Gen10
and HPE D6020 direct-attached storage. The functions within the appliance minimum configuration rack include:
• The PDW Base Scale Unit (PDW Server Kits (2) and Storage Kit (1)) is where the physical data warehouse or data mart is
stored.
- Tables are stored on 2 compute nodes, with the data stored on each node's D6020 storage. 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. 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 HPE
ConvergedSystem 300 for Microsoft Analytics Platform is able to access the data in p
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 based on capacity needs of the data warehouse.
• The Orchestration/Failover Server Kit (Passive Server Kit), with optional third node provides the follow functionality:
- Accept 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
or Power BI Desktop, while others may go through an application tier or OLAP cube such as SQL Server Analysis
Services.
HPE ConvergedSystem 300 for Microsoft Analytics Platform and
QuickSpecs
HPE ConvergedSystem 300 for Microsoft Analytics Platform
Overview
Page 3
Optional components
Data Integration Platform
The Data Integration Platform (DIP) refers to one or more servers you may elect to accompany your purchase of an HPE
ConvergedSystem 300 for Microsoft Analytics Platform solution. You may also choose to re
servers in your environment to provide this functionality. The Data Integration Platform server(s) provides:
For detailed information on the Data Integration Platform server and connectivity options to the Conver
Microsoft Analytics Platform,
website
Insight Remote Support Server Host
You can unlock all the benefits of your technology investment by connecting your products to HPE. HPE developed Insight Remote
Support (IRS) to provide 24x7 real
i
100% diagnostic accuracy and a single consolidated view of your environment.
By connecting, you receive 24x7monitoring, pr
service request submission will save you time monitoring and reporting issues. Collection of configuration information from y
devices will help HPE resolve problems more q
managed according to the HPE Data Privacy policy). Intelligent analysis of issues provides faster restoration of your monitor
devices to operational status.
HPE Proactive Care service and HPE Datacenter Care customers will also benefit from proactive reports and issue prevention
activities. For more details, please see
To enjoy this proactive support experience, you can add the IRS Monitoring software to the recommended configuration
(information in Step 7) which can optionally be ordered along with the HPE ConvergedSystem 300 for Microsoft Analytics Plat
You may also use an existing server for that purpose. IRS can also be installed on your Windows Hosting Device or VMware®, Ci
or Hyper
For more information about the HPE Converged
see:
For more information about HPE ProLiant servers see:
For more information about HPE Insight software, see:
For more information about Storage products, see:
For more information about HPE Racks see:
For more information about the HPE and Microsoft partnership see: http://www.hpe.com/partners/microsoft
-purpose an existing server or set of
• Intermediate location for backups (and therefore a staging area for restore operations)
• A staging location for Extract, Transform, and Load (ETL) or ELT operations, need to load data into the ConvergedSystem
300 for Microsoft Analytics Platform, a server is required.
gedSystem 300 for
please refer to the Data Integration Platform – Gen10 reference located on the
: http://www.hpe.com/products/cs300aps.
-time hardware event monitoring and secure Internet event submission to help you reduce risk,
dentify and prevent potentially critical problems for your environment. IRS allows to achieve up to 77% reduction in down time, near
e-failure alerts, automatic call logging, and automatic parts dispatch. Automatic
our
uickly and accurately. (Note, no business information is collected and the data is
ed
http://www.hpe.com/info/insightremotesupport.
-V virtual guest and easily configured to monitor your environment.
System 300 for Microsoft Analytics Platform
http://www.hpe.com/products/cs300aps
http://www.hpe.com/info/rackandpower
http://www.hpe.com/info/proliant
http://www.hpe.com/info/servermanagement
http://www.hpe.com/info/storage
form.
trix
QuickSpecs
HPE ConvergedSystem 300 for Microsoft Analytics Platform
How to Order
Page 4
How to order HPE
The method for purchasing the HPE ConvergedSystem 300 for Microsoft Analytics Platform is simple. Start
http://www.hpe.com/services/proactivecare
ConvergedSystem
300 for Microsoft
Analytics Platform
by ordering a PDW Region Base Scale Unit which is comprised of two PDW Server Kits,
Orchestration/Failover Servers (Passive Server Kits), and one Storage Kit. You can expand up to three
additional data scale units in the first rack. For additional capacity beyond a single rack, scale units can be
added to grow up to 7 racks of capacity.
NOTE: All racks purchased must be co-located, side by side.
NOTE: For detailed ordering information please see the Configuration Information section
NOTE: HPE Factory Express Services are included as part of the HPE ConvergedSystem 300 for
Microsoft Analytics Platform, providing factory integration and onsite deployment services. They feature:
An assigned project manager to oversee factory and customer site installation activities,
•
including capture of customer specific parameters, proactive communication, planning and
scheduling for a coordinated installation at the customer site.
The majority of the configuration is performed in the HPE factory to allow for a quicker
•
deployment by delivering a ready-to-deploy solution that is pre-configured and tested. Factory
integration includes racking, point-to-point cabling, labeling per HPE's guideline, configuration of
Ethernet and IB switches and iPDUs, server iLO configuration, Microsoft Analytics Platform
System 2016 and Windows OS software load and configuration, Firmware/BIOS update;
Microsoft Analytics Platform System Software Validation test.
A documentation package that details the configuration and settings of the delivered solution,
•
including diagrams of the hardware layout and point-to-point cabling
A choice of HPE support services is available to meet your business needs. The recommended HPE support
level is HPE Proactive Care Advanced (with a choice of 4 hour onsite response 24X7 or 6 hour call-torepair). The minimum required support level is HPE Proactive Care 24X7.
For additional information please visit:
HPE Factory Express:
HPE Support services:
HPE Proactive Care services:
http://www.hpe.com/info/factoryexpress
http://www.hpe.com/services/support
QuickSpecs
HPE ConvergedSystem 300 for Microsoft Analytics Platform
Standard Features
Page 5
Microsoft Analytics
Microsoft SQL Server software augmented with the MPP engine uses massively parallel processing (MPP) to
deliver high performance
architecture helps enable better scalability, better and more predictable performance, reduced risk and a
lower cost per terabyte than other data warehousing solutions.
Microsoft SQL Server software partitions large tables across multiple physical nodes, each node having
dedicated CPU, memory and storage, and each running its own instance of SQL Server, in
nothing architecture. SQL delivers improved perfor
NOTE:
Edition
Center 2012 Standard SP1 on thi
License program agreement under which you have acquired licenses to these Microsoft products. You
may not use the above software without first acquiring valid server and/or client acces
Microsoft or its authorized distributor or reseller.
with Software Assurance may be used to license and run SQL Server PDW on the Analytics Platform
System appliance
cloud/products/analytics
HPE Factory
HPE Factory Express Deployment Service for HPE ConvergedSystem 300 for Microsoft Analytics Platform
provides factory integration, onsite installation services, and end
through go
The service starts with factory integration of the
racked and stacked, along with cabling and labeling. After configuring the hardware, the software is loaded
and configured: Windows® operating system; Microsoft
is then loaded to conform to the Microsoft Reference Architecture specifications.
tests are conducted, and full appliance diagnostics are performed before systems leave the factory.
Onsite basic installation at the Customer
all hardware components have power.
After HPE has installed the appliance into your data center and connected it to power,
m web based
As part of thi
demonstrate the backup and restore procedures of the data and hand over operations to your organization.
Platform software
and scalability on SQL Server and Windows Server® 2012 R2. The MPP
mance through its unique design.
Your use of Microsoft Windows Server 2012 R2, Microsoft SQL Server Parallel Data Warehouse
or SQL Server Enterprise and the Virtual Machine Manager component of Microsoft System
s server hardware is subject to the terms and conditions of the Volume
SQL Server Enterprise Edition (SQL EE) core licenses
For more information see: http://www.microsoft.com/en-us/server-
-platform-system/Purchasing.aspx
Express for HPE
ConvergedSystem
-live stage.
-to-end project management from ordering
300 for Microsoft
Analytics Platform
base rack: servers, storage, switches, and PDUs, which are
Analytics Platform System 2016. The firmware/BIOS
’s site includes a hardware check and visual acknowledgment that
• Startup and appliance validation
• IP reconfiguration if factory settings need to be changed
• HPE Flex Fabric 5900 (Ethernet) switch configuration based on the CID/site survey and customer
network integration requirements.
• Demonstrate connectivity to the ConvergedSystem 300 for Microsoft Analytics Platfor
administration console.
• Install Client Tools and Microsoft SQL Server Data Tools. Generate and load line Items TPC/H test
data
• Execute test queries on the Line Items test table
• Optional: Install and configure HPE Insight Remote Support on a server and configure the
ConvergedSystem300 for Microsoft Analytics Platform in order to connect to it.
• Optional: If the Data Integration Platform is ordered:
- Configure the Data Integration Platform with Windows 2012 Standard, Mellanox IB card
drivers and IP configuration settings
- Test Data Integration Platform connectivity with the ConvergedSystem 300 for Microsoft
Analytics Platform..
- Demonstrate a backup and restore operation of the test database on the Data Integration
Platform (if ordered)
s service, we will also explain the operational management of the system as well as
parallel shared
s licenses from
PDW Appliance Validation
it then provides:
QuickSpecs
HPE ConvergedSystem 300 for Microsoft Analytics Platform
Standard Features
Page 6
A complete documentation package is provided in electronic form that details the configuration and settings
of the delivered solution. Included will be a system installation guide, a rack elevation drawing, a system
interconnect drawing, and a hardware/software system configuration guide.
Factory Express Deployment
H8A03A1
203 for adding
expansion racks to an existing base rack. When adding scale units (Add Capacity PDW), H8
(one per order) and H8A03A1
ConvergedSystem 300 for Microsoft Analytics Platform.
NOTE:
(CID
CID Reference ID# is required to be in place prior to sale. Before issuing a purchase order against this
solution, please contact your
Engagement Project Manager (EPM) who will manage the CID process.
For additional information please visit:
Datasheet for HP Factory Express Deployment Service for HP Converged Systems:
https://www.hpe.com/h20195/v2/GetPDF.aspx/4AA5
HPE Support
After a successful deployment, HPE and Microsoft work together to provide a solution level support
experience for the ConvergedSystem300 for Microsoft Analytics Platform.
HPE and Microsoft collaborate to provide a seamless support experience. The default route for first call is to
Microsoft where the dedicated APS/PDW software team triage the i
problem is hardware related.
Customers also have the option to make the first call into the
Advanced Solution
Center who will provide holistic support of the entire ConvergedSystem 300 for Microsoft Analytics Platform
and collaborate with Microsoft for APS/PDW software related issues.
Support for the HPE ConvergedSystem300 for Microsoft Analytics Platform requires both support from
Hewlett Packard Enterprise from the choices outlined below
with Microsoft.
The recommended Hewlett Packard Enterprise support level is HPE Proactive Care Advanced. The
NOTE:
aligned collaborative processes between Hewlett Packard Enterprise and Microsoft
NOTE:
with DMR (defective media retention).
HPE Proactive Care – 3, 4 or 5 Year
HPE Proactive Care for the ConvergedSystem 300 for Microsoft Analytics Platform begins with providing all
of the benefits of proactive monitoring and reporting along with access to Hewlett Packard Enterprise
specially trained people to provide a complete s
fundamentals needed for stability and availability of the Microsoft Analytics Platform environment. Proactive
Care helps in problem prevention, with predictive analytics, personalized analysis with recommendations and
advice paired with rapid access to technical experts to help rapidly resolve any problem. You receive an
enhanced call experience with advanced technical expertise, a single point of contact for the support of all
components and end
reactive processes between Hewlett Packard Enterprise and Microsoft.
services are also required when adding equipment to the base rack:
-202 for expansion racks ordered at the same time as a base rack, and, H8A03A1A03A1-204
-205 (one per server kit) are used to add capacity to an existing HPE
The factory integration services included in this solution require a Customer Intent Document
)to assist with the configuration and successful installation and implementation of the solution. The
Hewlett Packard Enterprise sales representative to engage an HPE
-3488ENN.pdf
Services
ssue and collaborate with HPE if the
Hewlett Packard Enterprise
, and a separate software support agreement
•
minimum required support level is HPE Proactive Care – 3 years (included).
• Software support for the Microsoft software must be purchased from Microsoft, We highly
recommend Premier Support for the Analytics Platform System (APS), available separately from
Microsoft.
Hewlett Packard Enterprise and Microsoft collaborate to resolve issues, leveraging specially
Each of these support levels include hardware and software reactive support and are available
olution-level support experience and put in place the
-to-end case ownership. You also benefit from the specially aligned, collaborative
.
Loading...