Azure Data Warehouse Health Check Query

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.

Comments (0)

Skip to main content