Appliance: Parallel Data Warehouse (PDW)

PDW is a massively parallel processing data warehousing appliance built for any volume of relational data (with up to 100x performance gains) and provides the simplest integration to Hadoop.

  • SQL Server 2012 Parallel Data Warehouse
  • Watch What's New in SQL Server 2012 PDW in the PASS Summit Keynote

    Unlike other vendors who opt to provide their high-end appliances for a high price or provide a relational data warehouse appliance that is disconnected from their “Big Data” and/or BI offerings, Microsoft SQL Server Parallel Data Warehouse provides both a high-end massively parallel processing appliance that can improve your query response times up to 100x over legacy solutions as well as seamless integration to both Hadoop and with familiar business intelligence solutions. What’s more, it was engineered to lower ongoing costs resulting in a solution that has the lowest price/terabyte in the market.

    What's New in SQL Server 2012 Parallel Data Warehouse

    Key Capabilities

    • Built For Big Data with PolyBase

      SQL Server 2012 Parallel Data Warehouse introduces PolyBase, a fundamental breakthrough in data processing used to enable seamless integration between traditional data warehouses and “Big Data” deployments.

      • Use 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.

    • Next-Generation Performance at Scale

      Scale and perform beyond your traditional SQL Server deployment with PDW’s massively parallel processing (MPP) appliance that can handle the extremes of your largest mission critical requirements of performance and scale.

      • Up to 100x faster than legacy warehouses with xVelocity updateable columnstore.
      • Massively Parallel Processing (MPP) architecture that parallelizes and distributes computing for high query concurrency and complexity.
      • Rest assured with built-in hardware redundancies for fault tolerance.
      • Rely on Microsoft as your 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 by lowering the cost of the appliance.

      • Resilient, scalable, and high performance storage features built into software lowering hardware costs.
      • Compress data up to 15x with the xVelocity 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 without retaining new tools or knowledge for scale-out DW or Big Data.
      • Co-engineered with hardware partners offering highest level of product integration and shipped to your door offering fastest time to value.
      • The lowest price/terabyte than overall appliance market (and 2.5x lower than SQL 2008 R2 PDW).

    Related Solutions

    Lowest Price/TB in the Market

    Microsoft SQL Server 2012 PDW has the lowest price/TB in the market.

    Microsoft SQL Server 2012 PDW has the lowest price/TB in the market.

    PolyBase

    PolyBase is a breakthrough innovation to unify relational and non-relational data.

    PDW has been deployed by leading organizations:

    Resources