Just a few clicks to configure Workload Management

Published Aug 21 2020 08:31 AM 1,394 Views
Microsoft

We announced the general availability of workload isolation for Azure Synapse Analytics which allows data engineers to configure and manage resources across their workloads to meet their business and performance objectives. This experience is not only available using familiar T-SQL syntax but we have also introduced the public preview of a graphical user interface in the Azure portal to provide a guided experience to the entire workload management process.

 

The Azure portal workload management experience comes with built-in commonly used views and charts which dynamically update allowing you to:

 

  • Immediately identify how much shared resources are available that have not been allocated and reserved to a particular workload group across the entire SQL pool. You can also quickly understand the distribution of resources across your workload groups.

WLM_Shared_Distributed_Resources.png

 

 

  • Leverage built-in charts to monitor resource allocation, query timeouts, active and queued queries per workload group.

WLM_Monitor.png

 

 

  • Pinpoint changes in the Effective Values of your workload group based on your service level objective and shared resources.

WLM_EffectiveValues.png

 

 

 

Using these views and charts, you can balance resource demands of various workloads under concurrency and ensure your workload groups are not underutilized or overloaded. This can be done easily by creating, updating, or even deleting workload groups and classifiers both in T-SQL and directly in the portal:

 

WLMCrud.png

 

 

 

The process of employing effective workload management practices has never been easier with the code-free experience in the Azure portal.

 

Try it out today! If you have feedback on the preview of this experience, reach out to the following distribution list: SynapseSQLStudioFeedback@service.microsoft.com

 

For more information on workload management, see the following documentation:

 

 

1 Comment
Contributor

Hi,

is it possible to change the workload immediately? Are there any environmental downtimes?

%3CLINGO-SUB%20id%3D%22lingo-sub-1597244%22%20slang%3D%22en-US%22%3EJust%20a%20few%20clicks%20to%20configure%20Workload%20Management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1597244%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20announced%20the%20general%20availability%20of%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fsynapse-analytics%2Fsql-data-warehouse%2Fsql-data-warehouse-workload-isolation%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Eworkload%20isolation%20for%20Azure%20Synapse%20Analytics%3C%2FA%3E%20which%20allows%20data%20engineers%20to%20configure%20and%20manage%20resources%20across%20their%20workloads%20to%20meet%20their%20business%20and%20performance%20objectives.%20This%20experience%20is%20not%20only%20available%20using%20familiar%20T-SQL%20syntax%20but%20we%20have%20also%20introduced%20the%20public%20preview%20of%20a%20graphical%20user%20interface%20in%20the%20Azure%20portal%20to%20provide%20a%20guided%20experience%20to%20the%20entire%20workload%20management%20process.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Azure%20portal%20workload%20management%20experience%20comes%20with%20built-in%20commonly%20used%20views%20and%20charts%20which%20dynamically%20update%20allowing%20you%20to%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EImmediately%20identify%20how%20much%20shared%20resources%20are%20available%20that%20have%20not%20been%20allocated%20and%20reserved%20to%20a%20particular%20workload%20group%20across%20the%20entire%20SQL%20pool.%20You%20can%20also%20quickly%20understand%20the%20distribution%20of%20resources%20across%20your%20workload%20groups.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22WLM_Shared_Distributed_Resources.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213184i501928ED088A8B80%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WLM_Shared_Distributed_Resources.png%22%20alt%3D%22WLM_Shared_Distributed_Resources.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ELeverage%20built-in%20charts%20to%20monitor%20resource%20allocation%2C%20query%20timeouts%2C%20active%20and%20queued%20queries%20per%20workload%20group.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22WLM_Monitor.png%22%20style%3D%22width%3A%20480px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213186i89C49D7520701CE3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WLM_Monitor.png%22%20alt%3D%22WLM_Monitor.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EPinpoint%20changes%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Ft-sql%2Fstatements%2Fcreate-workload-group-transact-sql%3Ftoc%3D%252Fazure%252Fsynapse-analytics%252Fsql-data-warehouse%252Ftoc.json%26amp%3Bbc%3D%252Fazure%252Fsynapse-analytics%252Fsql-data-warehouse%252Fbreadcrumb%252Ftoc.json%26amp%3Bview%3Dazure-sqldw-latest%23effective-values%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EEffective%20Values%3C%2FA%3E%20of%20your%20workload%20group%20based%20on%20your%20service%20level%20objective%20and%20shared%20resources.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22WLM_EffectiveValues.png%22%20style%3D%22width%3A%20977px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213179i19776FB52F918E78%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WLM_EffectiveValues.png%22%20alt%3D%22WLM_EffectiveValues.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUsing%20these%20views%20and%20charts%2C%20you%20can%20balance%20resource%20demands%20of%20various%20workloads%20under%20concurrency%20and%20ensure%20your%20workload%20groups%20are%20not%20underutilized%20or%20overloaded.%20This%20can%20be%20done%20easily%20by%20creating%2C%20updating%2C%20or%20even%20deleting%20workload%20groups%20and%20classifiers%20both%20in%20T-SQL%20and%20directly%20in%20the%20portal%3A%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-center%22%20image-alt%3D%22WLMCrud.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213178i4F0ABB2149488480%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WLMCrud.png%22%20alt%3D%22WLMCrud.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20process%20of%20employing%20effective%20workload%20management%20practices%20has%20never%20been%20easier%20with%20the%20code-free%20experience%20in%20the%20Azure%20portal.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20it%20out%20today!%20If%20you%20have%20feedback%20on%20the%20preview%20of%20this%20experience%2C%20reach%20out%20to%20the%20following%20distribution%20list%3A%20%3CA%20href%3D%22mailto%3ASynapseSQLStudioFeedback%40service.microsoft.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESynapseSQLStudioFeedback%40service.microsoft.com%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20more%20information%20on%20workload%20management%2C%20see%20the%20following%20documentation%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fsynapse-analytics%2Fsql-data-warehouse%2Fsql-data-warehouse-workload-management%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EWorkload%20management%20overview%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fsynapse-analytics%2Fsql-data-warehouse%2Fanalyze-your-workload%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EHow-to%20guide%20on%20analyzing%20your%20workload%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1597244%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Workload%20Management%20graphical%20user%20interface%20in%20the%20Azure%20Portal%20guides%20you%20through%20the%20process%20of%20manages%20resources%20for%20your%20analytic%20workloads.%26nbsp%3B%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-center%22%20image-alt%3D%22WLM_Preview.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213236iBF829800445F4967%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WLM_Preview.png%22%20alt%3D%22WLM_Preview.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1597244%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESynapse%20Administration%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESynapse%20Monitoring%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESynapse%20SQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Aug 21 2020 08:31 AM
Updated by: