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 currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a 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?

    Thanks
    Bernhard

  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….
    Thanks

  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.

    Thanks..
    Ahmet

  4. Ahmet says:

    —— it’s ok ;

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

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

    SELECT text
    FROM
    dbo.syscomments c
    JOIN sys.procedures p ON p.object_id = c.id
    WHERE
    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.

  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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>