Explore Microsoft Analytics Platform System

Breakthrough performance for big data analytics at an industry leading price

The Analytics Platform System brings Microsoft’s massively parallel processing (MPP) data warehouse technology–the SQL Server Parallel Data Warehouse (PDW)–together with HDInsight, Microsoft’s 100% Apache Hadoop distribution, and delivers it as a turnkey appliance. To integrate data from SQL Server PDW with data from Hadoop, APS offers the PolyBase data querying technology.

Read the APS datasheet Watch the APS video Read the APS solution brief Read the white paper on APS price performance Read the white paper on APS performance

Back to top

Leading UK bank gains rapid insight into customer needs and economic trends with SQL Server PDW solution

After implementing SQL Server PDW, part of the Microsoft Analytics Platform System, The Royal Bank of Scotland cut a typical four-hour query to less than 15 seconds.

Read the case study

Grocery chain operator improves data warehouse performance

The company deployed SQL Server Parallel Data Warehouse, part of the Microsoft Analytics Platform System, and has seen increased query performance by up to 100 times.

Read the case study

Back to top

Benefits

Up to 100x performance gains over legacy data warehouses
Relational and non-relational data in one appliance
Seamless integration of the relational data warehouse and Hadoop with PolyBase
Linear scale-out to 6 petabytes of user data capacity
The lowest price per terabyte for a data warehouse appliance in the industry

Back to top

Capabilities

Enterprise-ready big data

PolyBase provides a fundamental breakthrough in data processing by enabling seamless integration between traditional data warehouses and “big data” deployments.

A high performance MPP relational data warehouse, SQL Server PDW, and the HDInsight Hadoop solution together in the same appliance
Standard SQL queries (instead of MapReduce) to access and join Hadoop data with relational data
Query Hadoop data without IT having to pre-load data first into the warehouse
Native Microsoft BI integration allowing analysis of relational and non-relational data with familiar tools like Excel

Learn more about PolyBase

Next-generation performance at scale

Go beyond your traditional SQL Server deployment with PDW’s massively parallel processing appliance that can handle the extremes of your largest mission critical requirements.

Up to 100x faster than legacy warehouses with in-memory and updateable columnstore
Massively parallel processing architecture that parallelizes and distributes computing for high query concurrency and complexity
Built-in hardware redundancies for fault tolerance
Microsoft as a single point of contact for hardware and software support

Engineered for optimal value

Unlike other vendors in the data warehousing space who deliver a high-end appliance at a high price, Microsoft engineered PDW for optimal value through software innovations which result in a lower cost for the appliance.

Resilient, scalable, and high-performance storage features built into software, which lowers hardware costs
Reduced data center and management costs by combining a relational data warehouse with Hadoop in one appliance
Data compression up to 15x with the in-memory updateable columnstore, saving up to 70% of storage requirements
Start small with a quarter rack allowing you to right-size the appliance rather than over-acquiring capacity
Use the same tools and knowledge as SQL Server for scale-out data warehouse or big data
Co-engineered with hardware partners offering the highest level of product integration, and shipped to your door offering fastest time-to-value
The lowest price per terabyte for a data warehouse appliance

Back to top