Skip to content

Instantly share code, notes, and snippets.

@MarkPryceMaherMSFT

MarkPryceMaherMSFT/get_dwu_size2.sql

Created April 4, 2022 22:03
Show Gist options
  • Save MarkPryceMaherMSFT/ad229dd30494a90f405a315b1d423013 to your computer and use it in GitHub Desktop.
Save MarkPryceMaherMSFT/ad229dd30494a90f405a315b1d423013 to your computer and use it in GitHub Desktop.
Download ZIP
size of dedicated sql pool
Raw
get_dwu_size2.sql
-- Run against master database
SELECT db.name [Database]
, ds.edition [Edition]
, ds.service_objective [Service Objective]
FROM sys.database_service_objectives AS ds
JOIN sys.databases AS db ON ds.database_id = db.database_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment