Azure Data Warehouse Health Check Query

First published on MSDN on Jul 14, 2017
We have been sharing this query with the customers to have a quick health check on their environment. The query covers these items:

• Checking basic statistics information (actual row count vs row count for control node)


• Table data skew


• Small CCI tables (<102400 rows per partition) – This is just for their reference for reviewing their tables.


• CCI tables with more than 10% deleted rows


• CCI tables with smaller row groups

This script will drop the temp tables created at the end of the script.