Page tree
Skip to end of metadata
Go to start of metadata

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

Excerpt Macro - Logs - Full Analysis Image for 83

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

  • No labels