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:
Hi James
Thanks for this information. But we still have a question:
Brings AU3 support for Stored Procs?
Thanks
Bernhard
Yes, AU3 has support for stored procedures.
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
Microsoft has some internal documents that has that info but I’m not sure if anyone outside Microsoft can get a copy.
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
—— 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
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.
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.
Hi Ahmet, Microsoft has that document. Contact the PDW team for it.
Hello,
Have you any download link for the document, includes migration procedures 2008 or 2012 server to PDW?
Thank you,
Okan
I am not aware of a document like that, but I will post it if I find it.
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
Hi James,
How to handle errors/Exceptions in PDW like, In SQL we handle with try, catch block.