Azure Synapse Analytics Queries #1 Current Data Warehouse Units

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. 

				
					-- Query the current allocation of data warehouse units (DWU) 
-- for your Azure Synapse Analytics SQL Pools
-- Execute the following query in the master database.
SELECT db.NAME               [Database],
       dso.edition           [Edition],
       dso.service_objective [Service Objective]
FROM   sys.database_service_objectives AS dso
       JOIN sys.databases AS db
         ON dso.database_id = db.database_id
WHERE  edition = 'DataWarehouse'; 
				
			

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://www.techtalkcorner.com/monitor-azure-data-factory-user-properties/

https://www.techtalkcorner.com/azure-data-factory-locks/

Azure Synapse Analytics Studio

Azure Synapse Analytics Studio

Azure Synapse Analytics Studio enables Data Engineers, Data Scientists and IT Professionals to collaborate. It’s a place where they can develop end-to-end data solutions within a single platform and experience.

Read More »
comment [ 0 ]
share
No tags 0

No Comments Yet.

Do you want to leave a comment?

Your email address will not be published.