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. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Platform: Dashboard Platform |
Control: Dashboard Datasources

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. 




 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.


You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon 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.Close Icon

Live Chat Icon For mobile