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.