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

SQL XXL table Quality Rules are performance related Quality Rules that help detect incorrect or poorly performing SQL queries running on XXL tables.

Below is the screen shot which shows where this step comes.

 The Loglines generated by this task is shown below



CAST-MS<ID>.log.txt

Run Update SQL XXL Table Size

INF: 2016-09-12 13:25:55: starting Task Update SQL XXL Table Size for "SilverLight_App"
INF: 2016-09-12 13:25:55: Task message: skipped : no Table Size data
INF: 2016-09-12 13:25:55: No associated log file
INF: 2016-09-12 13:25:55: ending Task Update SQL XXL Table Size for "SilverLight_App"

 

 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