We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to increase the performance of query processing in Azure SQL Data Warehouse?

To increase the performance of query processing, increase the number of DWUs (Data Warehouse Units) based on your working load. As the number of DWUs increases, SQL Data Warehouse runs operations in parallel (e.g. data load or query) across more distributed CPU and memory resources. This reduces latency and improves performance. 

 

To increase DWU refer the below screenshot. 

 

http://www.syncfusion.com/downloads/support/directtrac/194322/530956690_be543696.PNG

 

 Recommendations for finding the best DWU for your workload: 

  1. For a data warehouse in development, begin by selecting a small number of DWUs.
  2. Monitor your application performance, observing the number of DWUs selected compared to the performance you observe.
  3. Determine how much faster or slower performance should be for you to reach the optimum performance level for your requirements by assuming linear scale.
  4. Increase or decrease the number of DWUs in proportion to how much faster or slower you want your workload to perform. The service will respond quickly and adjust the compute resources to meet the new DWU requirements.
  5. Continue making adjustments until you reach an optimum performance level for your business requirements.

For more details, please click here.

 

Article ID: Published Date: Last Revised Date: Platform: Control:
8389 02/09/2018 02/12/2018 Dashboard Platform Dashboard Datasources
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.