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 Workspaces Experience

While we wait for Azure Synapse Analytics’ release for the general public, what information is already available about the new workspace experience? 

Microsoft announced Azure Synapse Analytics back in November 2019.

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. Required fields are marked *