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.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';
Table of Contents
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
This blog post outlines the steps to follow to create an Azure Synapse Analytics Workspace using the Azure portal.
Let’s take a closer look at this surprising service.