von Martin Pöckl 
5. April 2012 12:26
Gemeinsam mit dem Launch des SQL Server 2012 wurde auch ein Update für die SQL Server Parallel Datawarehouse Appliance (kurz: PDW) angekündigt. Für alle die es nicht Wissen: SQL Server PDW ist eine Data Warehouse Appliance (d.h. fertig konfigurierte Soft- + Hardware) die bis 600TB Datenbankgröße skaliert. Das Appliance Update (kurz: AU) bringt neben Soft- und Firmware immer auch Hardwareupdates – einer der Vorteile von Appliances! Verbessert werden diesmal die Performance (und zwar massiv!), die Verwaltung, die Programmiermöglichkeiten und nicht zuletzt die Unterstützung von 3rd Party Werkzeugen (z.B. für ETL, BI).
Die Erweiterungen im Detail:
| Feature | Benefit | Description |
| Cost based optimizer | - Better query performance via improved DSQL Plan generation
- Full alignment of security system and metadata
| Introduces a fully cost-based MPP optimizer. |
| DMS (Data Movement Services) | Dramatic improvement in query speed and appliance throughput | Removes data type conversions from Data Movement Server |
| ½ rack Appliances from Dell and HP | Lower price and entry level capacity for MPP data warehousing | - Dell ½ racks available now
- HP to ship ½ racks by April
|
| System Center Integration (SCOM pack) | - Lower cost of PDW monitoring and administration
- Seamless management of PDW and standard SQL Server instances
| Fully integrates PDW to Systems Center Operations Manager |
| Stored Procedures (subset) | - Greater application compatibility
- Closer affinity to SQL Server dramatically reduces system conversion effort and time
- Provides modular programming, standardization and re-usability
| - Introduces the Stored Procedure object to PDW
- Enriches programmability for PDW by putting process control closer to data objects
|
| TDS/MSFT (Native SQL Server drivers | - Enhanced PDW support for other SQL Server Applications
- Common connectivity stack as SQL Server SMP
| Tabular Data Stream – Native protocol for communicating with SQL Server. |
| More expressive query language | Ability to write and encapsulate query sophistication using ‘built-in’ T-SQL | Addition of more expressive functions to PDW T-SQL |
| Integration to SAS | Full integration to key 3rd party BI and ETL tools to leverage existing solutions and BI platform investments | Extends PDW integration to third-party tools to SAS |
| Collations | Full support for International Data | Extends PDW collation sequence beyond Latin Bin 2 |
Martin Pöckl
martin.poeckl@microsoft.com
