Actionable Data Analytics
Join Our Level Up Your Data Email List for Data News Sent to Your Inbox
In Databases

Azure Synapse Analytics Queries #1 Current Data Warehouse Units

Posted on
Pin it Azure Synapse Analytics Queries

If you are looking to query the current allocation of data warehouse units (DWU) for your Azure Synapse Analytics SQL Pools, execute the following query in the master database. This is useful when trying to identify how many resources you are allocating to each of your Azure Synapse SQL Pools. 

WHAT’S NEXT?       

In upcoming blog posts, we’ll continue to explore some of the features within Azure Services.       

Please follow Tech Talk Corner on Twitter for blog updates, virtual presentations, and more!           

As always, please leave any comments or questions below.       

Check out these other blog posts

https://davidalzamendi.com/monitor-azure-data-factory-user-properties/

https://davidalzamendi.com/azure-data-factory-locks/

comment [ 0 ]
share
No tags 0
As a Data Architect, I help organisations to adopt Azure data analytics technologies that mitigate some of their business challenges. I’ve been working in the data analytics space since 2011, mainly in the data warehousing area and I’m specialized in the design and implementation of data analytics solutions with Microsoft technologies. I am responsible for providing end-to-end technical guidance and expertise across multiple data analytics projects.
previously

previously

Azure Data Factory or Synapse Analytics Self-Hosted Integration Runtime Cluster
up next

up next

Azure Synapse Analytics Queries #2 Replicated Tables

No Comments Yet.

Do you want to leave a comment?

Your email address will not be published. Required fields are marked *

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.