Architecture Checker Component - Check Architecture Model - Performance issue

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

Step by Step scenario

1. Check Architecture Model
   

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:

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

         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"
         YYYY/MM/DD HH/MM/SS INF: [SQL] *** LONG ELAPSED TIME: X mn

4. Contact CAST Technical Support. with the following   relevant input 

Ticket # 11610