Skip to content

Instantly share code, notes, and snippets.

@MarkPryceMaherMSFT

MarkPryceMaherMSFT/how_many_nodes_distributions.sql

Created April 9, 2022 23:47
Show Gist options
  • Save MarkPryceMaherMSFT/6c29c96eb1821703755fa480bcae93c5 to your computer and use it in GitHub Desktop.
Save MarkPryceMaherMSFT/6c29c96eb1821703755fa480bcae93c5 to your computer and use it in GitHub Desktop.
Download ZIP
the number of nodes and distributions
Raw
how_many_nodes_distributions.sql
-- size
SELECT DATABASEPROPERTYEX (DB_NAME(), 'ServiceObjective' ) as ServiceObjective
-- How many nodes....
select * from sys.dm_pdw_nodes; -- DWU100 to DWU400
-- distributions
select * from sys.pdw_distributions
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment