SQL Server Parallel Data Warehouse (PDW) Appliance Update 3 (AU3)

In the next few weeks there will be an update to the SQL Server Parallel Data Warehouse (PDW) called “Appliance Update 3” or “AU3”.  More than just a cumulative update, an Appliance Update is a complete refresh on the entire solution including software, hardware, and firmware.  This is the third Appliance Update in the last 14 months and includes the following major new features:

  • Breakthrough performance with up to 10x improvement over prior releases through the new cost-based Query Optimizer and Data Movement Service
  • Ability to start small and scale with full and half-rack appliances; Dell has released a half-rack appliance and the HP half-rack is available in April
  • Best-in-class manageability with integration to System Center 2012 enabling IT to manage PDW seamlessly with other IT assets using a single pane of glass

PDW is a massively parallel processing (MPP) pre-built appliance designed to provide the highest scalability and performance for the most demanding data warehouse needs.  PDW appliances are available from HP (as HP Enterprise Data Warehouse Appliance) and Dell (as Dell Parallel Data Warehouse appliance) to scale well beyond hundreds of terabytes.  Check here for more info.

More info:

Microsoft Data Warehouse Features

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.
This entry was posted in Appliance, PDW/APS, SQLServerPedia Syndication. Bookmark the permalink.

13 Responses to SQL Server Parallel Data Warehouse (PDW) Appliance Update 3 (AU3)

  1. Bernhard says:

    Hi James

    Thanks for this information. But we still have a question:
    Brings AU3 support for Stored Procs?


  2. Alain says:

    Hi James,
    Do you know when I can find a doc. about limitation/features not supported for stored procedures? Like cursors and so on….

  3. Ahmet says:

    Hi James,

    Do you know where can i find my stored procedures on Nexus Chameleon?

    I just can see Databases, Tables, Views and Security but nothing about SP’s.


  4. Ahmet says:

    —— it’s ok ;

    SELECT *
    FROM dw_production.sys.all_objects
    is_ms_shipped = 0 AND type = ‘P’

    ——– you can find prodecure name here and search it like ;

    SELECT text
    dbo.syscomments c
    JOIN sys.procedures p ON p.object_id = c.id
    p.name = ‘procedure_name’
    ORDER BY number, colid

    • James Serra says:

      Yep Ahmet, you beat me to it. I was going to reply with the SQL you posted. Nexus does not yet have a way to view stored procedures like you can in SSMS. Hopefully soon we will be able to use SSMS instead of Nexus to hit PDW.

      • Ahmet says:

        Sounds good, that would be great. By the way, do we have a document which describes the syntax differences between Sql Server 2008 and PDW ? I have to migrate too many procedures to PDW but syntax errors makes me slow.

        Thank you.

  5. More Sql features, more optimized queries, that’s a really good news.. i need to go through all it’s features. Thanks for sharing the news though

  6. Yogesh says:

    Hi James,

    How to handle errors/Exceptions in PDW like, In SQL we handle with try, catch block.