SQL XXL table Quality Rules are performance related Quality Rules that help detect incorrect or poorly performing SQL queries running on XXL tables.
In 8.3, most of the XXL metrics definition and analysis is now done in the analyzer itself instead of in a step after analysis. See the following documentation page for more details on this: XXL and XXS tables rules enablement
In some legacy analysis cases, this will still be done outside of the analysis.
The remainder of this page will show the messages typical for a legacy analysis case.
Below is the screen shot which shows where this step comes.
The Loglines generated by this task is shown below
CAST-MS-<date>-<time>.log.txt log file
Run Update SQL XXL Table Size
INF: 2018-11-27 16:36:44: starting Task Update SQL XXL Table Size for "db_xxl"
INF: 2018-11-27 16:36:44: Task message: skipped : no Table Size data
INF: 2018-11-27 16:36:44: No associated log file
INF: 2018-11-27 16:36:44: ending Task Update SQL XXL Table Size for "db_xxl"
Update SQL XXL Table Size<Date Time>_CMS.castlog
2016-09-14 13:21:41.712 Information INTERNAL ; Body Using Knowledge Base on schema cast_80_sup_local. 0 ; 0 0 0 Common 0 0
2016-09-14 13:21:41.719 Information INTERNAL ; Body Importing 'C:\Users\KPA\Downloads\Desktop\Tablesize\squirrel_castpubs.sqltablesize' 0 ; 0 0 0 ToolsAnalysisJobImpl.dll 49 1 c:\build\8.0.164r\caip\src\analyzers\sqltools\toolsanalysisjobimpl\modulexxl.cpp
2016-09-14 13:21:41.719 Warning OBJIMPORT ; Body Cannot find server: oplt 0 ; 0 0 0 0 0