Home
%3CLINGO-SUB%20id%3D%22lingo-sub-368912%22%20slang%3D%22en-US%22%3EAzure%20Data%20Warehouse%20Health%20Check%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-368912%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Jul%2014%2C%202017%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20We%20have%20been%20sharing%20this%20query%20with%20the%20customers%20to%20have%20a%20quick%20health%20check%20on%20their%20environment.%20The%20query%20covers%20these%20items%3A%20%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EChecking%20basic%20statistics%20information%20(actual%20row%20count%20vs%20row%20count%20for%20control%20node)%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ETable%20data%20skew%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ESmall%20CCI%20tables%20(%26lt%3B102400%20rows%20per%20partition)%20%E2%80%93%20This%20is%20just%20for%20their%20reference%20for%20reviewing%20their%20tables.%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ECCI%20tables%20with%20more%20than%2010%25%20deleted%20rows%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ECCI%20tables%20with%20smaller%20row%20groups%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20This%20script%20will%20drop%20the%20temp%20tables%20created%20at%20the%20end%20of%20the%20script.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-368912%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Jul%2014%2C%202017%20We%20have%20been%20sharing%20this%20query%20with%20the%20customers%20to%20have%20a%20quick%20health%20check%20on%20their%20environment.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-368912%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eazure%20sql%20datawarehouse%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETSQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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.