CODEWITHSUNDEEP
azureconcurrencydata-warehouseazure-synapsesql-data-warehouse
Dataman
Dataman

Reputation: 27

Resource Class - Concurrency - Azure SQL Data Warehouse

I have a question on how exactly resource class and concurrency work in ADW. I have configured a user account as staticrc30 (4 concurrency slots) and I am using this account from Tableau dashboard. My dashboard makes total of 12 queries to ADW. I am running ADW at 400 DWUs which means it has 16 concurrency slots.Does all my 12 queries run in sequence OR they run in batches of 4? Even though each of my SQL Queries is taking less time overall dashboard rendering time is very long.

Upvotes: 0

Views: 522

Answers (1)

Ron Dunn
Ron Dunn

Reputation: 3078

You should be seeing four queries running concurrently, assuming nothing else is running on the DW at the time.

You can check this using the waiting queries DMV example, shown here:

https://learn.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-monitor#monitor-waiting-queries

If you're not seeing four running, think about whether your Tableau desktop has been configured to run parallel queries:

https://kb.tableau.com/articles/howto/Configuring-Parallel-Queries-in-Tableau-Desktop

Upvotes: 2

Related Questions