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';
Table of Contents
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
Azure Synapse Analytics Workspaces Experience
Azure Synapse Analytics is a one-stop-shop for analytics aimed at users of various levels, it combines big data and data warehousing capabilities. As someone who has been working in the data analytics space since 2011,
Create Your First Azure Synapse Analytics Workspace
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.
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.
