Architecture Checker Component - Check Architecture Model - Performance issue

Purpose (problem description)

This page helps in troubleshooting performance issues in AC where the Check Model takes unexpectedly long time

Observed in CAST AIP

ReleaseYes/No
8.3.x✅

Observed on RDBMS

RDBMSYes/No
CSS✅

Step by Step scenario

  1. Check Architecture Model

Action Plan

  1. Optimize the tables of local base, for this refer to CSS Tools - Optimize - Updating the statistics - using Cssoptimize exe on a schema, then Check Architecture Model.
  2. Vacuum the table of local schema, for this refer to Tools - How to VACUUM FULL tables of a schema, then Check Architecture Model.
  3. Enable SQL traces for this refer to Architecture Checker - Information - How to launch Architecture Checker in SHOW SQL mode,
    1. Check Architecture Model
    2. Open AC log file, refer to the following page for the log location CAST Management Studio - Information - How to find logs.

      1. The issue can be due to the fact that Architecture Checker is stuck in the computation of a procedure or a query.This case is identified when the computation takes very long time without returning any message after this procedure. 
        Example:

YYYY/MM/DD HH/MM/SS INF: [SQL] Insert into <Knowledge_Base>.PMC_ARCHI_ALLOW_LINKS select * from <local_db>.PMC_EXPAND_SUBOBJECTS ( 0, 15 ) where PMC_EXPAND_SUBOBJECTS = -999999"

      2. If it is really a performance issue, then we need to identify the procedure(s) that takes a long time, this is identified by searching for the following message inside the log file:

         ```sql
YYYY/MM/DD HH/MM/SS INF: [SQL] *** LONG ELAPSED TIME: 10 mn

     **Example:**

     ```sql

YYYY/MM/DD HH/MM/SS INF: [SQL] Insert into <Knowledge_Base>.PMC_ARCHI_ALLOW_LINKS select * from <local_db>.PMC_EXPAND_SUBOBJECTS ( 0, 15 ) where PMC_EXPAND_SUBOBJECTS = -999999" YYYY/MM/DD HH/MM/SS INF: [SQL] *** LONG ELAPSED TIME: X mn

4. Contact [CAST Technical Support](https://help.castsoftware.com/hc/en-us/requests/new). with the following   [relevant input](/export-v2/tg/technical-guides/technical-guides-by-cast-aip-component/architecture-checker-component/)

 

**Notes/comments**

Ticket # 11610

**Related Pages**