Azure Data Warehouse Health Check Query

Published Mar 13 2019 06:44 PM 799 Views
Microsoft
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.

Version history
Last update:
‎Mar 13 2019 06:44 PM
Updated by: