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.