7/31/2019 2008 SQL R2 - Parallel Data WareHouse

1/2

Monster Scale at Low Cost!

MicrosoftSQLServer2008R2ParallelDataWarehou

Parallel Data Warehouse

SQLServer2008R2Appliance

Data deluge has become an all too familiar concept to organizations

over the last decade. In the next few years, organizations will begin to

acquire hundreds of terabytes if not petebytes of data. While symmetric

multi-processing (SMP) works well for small data warehouses and data

marts, many organizations are adopting massively parallel processing

(MPP) architectures to effectively manage, store, and unlock valuable

business insights from complex data.

Microsoft SQL Server 2008 R2 Parallel Data Warehouse is built on

MPP technology that provides enterprise-class performance and

scalability, flexibility and choice of hardware vendors, and the most

comprehensive data warehouse solution through integration with bothMicrosoft and non-Microsoft Business Intelligence tools.

Key Benefits

High scale from tens to hundreds of terabytes Flexibility and choice of hardware with appliances from HP and Dell Low cost through industry standard hardware First-class integration with Microsoft BI and heterogenous BI

environments through customized connectors

Interoperability with Hadoop through new Hadoop connectors Reduced risk through pretested configurations Predictable performance through balanced reference architectures

For IT decision makers with the most demanding data warehouses,

Parallel Data Warehouse offers massive scalability to hundreds of

terabytes and high performance through an MPP architecture. Unlike

competitors, Parallel Data Warehouse offers flexibility and choice with

leading hardware vendors such as HP and Dell. It also provides the most

complete data warehouse platform with a complementary toolset for

ETL, BI, master data management (MDM), and real-time data

warehousing. For customers with heterogenous BI environments, Parallel

Data Warehouse works seamlessly with SAP Business Objects,

Informatica and Microstrategy. In addition, through customized

connectors for Hadoop, Parallel Data Warehouse enables customers to

analyze structured and unstructured data in a Data Warehouse or

Hadoop environment.

Enterprise Scale Data WarehouseThrough an MPP architecture with a shared nothing design, Parallel Data

Warehouse delivers predictable performance to an increasing number

of users accessing the data warehouse.

Parallel Data Warehouse offers customers:

Enterprise-class scalability to hundreds of terabytes High performance through a shared nothing architecture Enterprise-level support and maintenance

Mature SQL Server platform with high security and robengineering processes

Strong data warehousing vision and road map that includindustry-leading technologies

Flexibility and ChoiceUnlike competitors, the Parallel Data Warehouse offers a choice

hardware thanks to our strategic partnership with HP and D

Through a distributed architecture, it offers additional flexibility t

enables organizations to deploy data warehouses that meet th

business needs. As a result, Parallel Data Warehouse off

customers:

Choice of hardware vendors, which leads to: Flexibility and no vendor lock in. Low hardware and maintenance cost. Less risk and disruption to hardware standards.

Choice of deployment options through: A unique distributed architecture that supports an MPP a

SMP Data Warehouses.

Support for users with different needs and service-levelagreements (SLAs).

7/31/2019 2008 SQL R2 - Parallel Data WareHouse

2/2

Thisdatasheetisforinformationalpurposesonly.MICROSOFTMAKESNOWARRANTIES,EXPRESSORIMPLIED,INTHISSUMMARY.2011MicrosoftCorporation

DistributedDataWarehouseArchitecture

n addition, Parallel Data Warehouse offers:

Multiple configurations from HP and Dell White glove service and support through Microsofts Critical

Advantage Program

Use of industry standard hardware Low acquisition cost, with appliances starting from under $13,000

per terabyte

Distributed architecture with SQL Server 2008 R2 Parallel DataWarehouse as the hub and SQL Server Fast Track Data Warehouse

data marts as the spokes

Most Comprehensive SolutionParallel Data Warehouse offers more than just a data warehouse

engine. It offers a comprehensive data warehouse solution with a

complementary set of tools for ETL, analysis, reporting, MDM, and real-

time data warehousing. As a result customers benefit from:

A complete data warehouse solution spanning desktops, datamarts, and the enterprise data warehouse.

A compelling end-user BI experience. Agility with ability to support new business groups with integrated

data marts.

Fast time-to-value for BI through integration with Microsoft BI.Parallel Data Warehouse also offers: Distributed architecture that integrates both MPP and SMP data

warehouses

Integration with Microsoft BI tools, including Analysis Services,Integration Services, and Microsoft SharePoint

Most comprehensive toolset for ETL, BI, MDM and Streaming Data. Interoperability with non-Microsoft BI and ETL tools such as, SAP

Business Objects, Informatica, and Microstrategy.

Hadoop connectors for seamless integration between Parallel DataWarehouse and the Hadoop environment.

Key Features

Feature Benefits

Parallel Loader Evenly distributed data across multiplnodes and parallel processing

High performance and efficiencyParallel Database Copy Better agility and business alignment

High-speed data transfer to relievetraditional barriers to hub-and-spoke

Parallel Backup and

Restore

Reduced administration for large datawarehouses

Ability to archive backup files in anexternal device or system

Multiple Physical

Instances

of Tables

Fewer performance bottlenecks Enterprise-class redundancy by

mirroring all server and storage

components

Massively Parallel

Processing with Shared

Nothing Architecture

Better scalability, better and morepredictable performance, reduced risk

and a lower cost per terabyte

Ability to partition data across nodes treduce bottlenecks and contention

IO and CPU Affinity within

SMP Nodes

Eliminated contention per user queryIncreased process performance using

resources of the node for each query

Microsoft Critical Advantage Program (MCAP)To ensure business continuity of your mission critical data wareho

appliance, MCAP combines pre-packaged, pre-tested hardware a

software configurations with enterprise-class proactive services a

support options over the complete lifecycle of your solution.

ServicesExperienced Microsoft Services professionals will conduct a comprehens

proactive review of your architecture, as well as your IT operations relat

to the appliance. They will incorporate recommended practices that w

improve the ultimate performance and stability of your mission crit

solution.

SupportWith MCAP, Microsoft is your first point of contact for assistance; we tria

the problem and collaborate with the hardware support team, manag

the incident end to end. MCAP appliances such as SQL Server 2008

Parallel Data Warehouse are sold with mandatory support (Softw

Assurance and Premier) agreement to ensure proper operations ahardware and servicing. Optionally you can upgrade this support to o

mission critical support offering (Software Assurance and Premier Miss

Critical), our highest level of support available.

Additional Information

For more information about SQL Server 2008 R2 Parallel Data Warehous

go towww.microsoft.com/pdw.

http://www.microsoft.com/pdwhttp://www.microsoft.com/pdwhttp://www.microsoft.com/pdwhttp://www.microsoft.com/pdw