Unlock Query Performance with SQL Data Warehouse using Graphical Execution Plans

%3CLINGO-SUB%20id%3D%22lingo-sub-162784%22%20slang%3D%22en-US%22%3EUnlock%20Query%20Performance%20with%20SQL%20Data%20Warehouse%20using%20Graphical%20Execution%20Plans%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-162784%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Graphical%20Execution%20Plan%20feature%20within%20SQL%20Server%20Management%20Studio%20(SSMS)%20is%20now%20supported%20for%20SQL%20Data%20Warehouse%20(SQL%20DW)!%20With%20a%20click%20of%20a%20button%2C%20you%20can%20create%20a%20graphical%20representation%20of%20a%20distributed%20query%20plan%20for%20SQL%20DW.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBefore%20this%20enhancement%2C%20query%20troubleshooting%20for%20SQL%20DW%20was%20often%20a%20tedious%20process%2C%20which%20required%20you%20to%20run%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Ft-sql%2Fqueries%2Fexplain-transact-sql%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EEXPLAIN%20command%3C%2FA%3E.%20SQL%20DW%20customers%20can%20now%20seamlessly%20and%20visually%20debug%20query%20plans%20to%20identify%20performance%20bottlenecks%20directly%20within%20the%20SSMS%20window.%20This%20experience%20extends%20the%20query%20troubleshooting%20experience%20by%20displaying%20costly%20data%20movement%20operations%20which%20are%20the%20most%20common%20reasons%20for%20slow%20distributed%20query%20plans.%20Below%20is%20a%20simple%20example%20of%20troubleshooting%20a%20distributed%20query%20plan%20with%20SQL%20DW%20leveraging%20the%20Graphical%20Execution%20Plan.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22f4844612-a0b4-4eae-a9da-e49f662627bc.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F29036i1B69A57CB28618AA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22f4844612-a0b4-4eae-a9da-e49f662627bc.png%22%20alt%3D%22f4844612-a0b4-4eae-a9da-e49f662627bc.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERead%20more%20about%20it%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fblog%2Funlock-query-performance-with-sql-data-warehouse-using-graphical-execution-plans%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20blog%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-162784%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EData%20%26amp%3B%20Storage%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Warehouse%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Community Manager

The Graphical Execution Plan feature within SQL Server Management Studio (SSMS) is now supported for SQL Data Warehouse (SQL DW)! With a click of a button, you can create a graphical representation of a distributed query plan for SQL DW.

 

Before this enhancement, query troubleshooting for SQL DW was often a tedious process, which required you to run the EXPLAIN command. SQL DW customers can now seamlessly and visually debug query plans to identify performance bottlenecks directly within the SSMS window. This experience extends the query troubleshooting experience by displaying costly data movement operations which are the most common reasons for slow distributed query plans. Below is a simple example of troubleshooting a distributed query plan with SQL DW leveraging the Graphical Execution Plan.

 

f4844612-a0b4-4eae-a9da-e49f662627bc.png

 

Read more about it in the Azure blog.

0 Replies