Currently upgrading to CA Gen 8.6.
Part of the testing is comparing CSE generation performance of the current CSE (Gen 8.5/Windows/Oracle) versus the new CSE (Gen 8.6/Windows SQL Server).
Noticed a significant difference in the time it takes to build the Java Cooperative client (WUI) application.
- Microsoft Windows Server 2012 R2
- Dual code Intel Xeon CPU E5-2637 @ 3.5GHz
- 256 GB RAM
- Oracle 12
- Microsoft Windows Server 2019
- Quad code Intel Xeon CPU E7-4860 @ 2.6GHz
- 32 GB RAM
- Microsoft SQL Server 2019
The generation takes 10 hours for the current 8.5 Windows 2012 R2/Oracle CSE - can this be improved on?
The new 8.6 Windows 2019/SQL Server test CSE is currently taking 18 hours.
The Object Cache on both CSEs is set very high at 25 million i.e. 25000000.
Release : 8.5, 8.6
Component : CA Gen Client Server Encyclopedia
Support obtained a copy of the customer's model and tested the cooperative generation for the whole model on a Windows Server 2019 Standard/SQL Server 2019 CSE VM.
The latest Gen 8.6 PTFs for Gen Complete (WKS86200) and CSN* PTFs are installed.
The DB is completely untuned i.e. OOTB installation.
The Object Cache is set to 1 million i.e. 1000000
The CSE only has the customer's model uploaded and no others.
Trace and Install options were selected for the generation
The SQL Server CSE VM System Information is:
Windows Server 2019 Standard
Processor: Intel Xeon Gold 5120 CPU @ 2.20GHz 2.19GHz (8 processors)
Memory (RAM): 16 GB
The SQL Server details from running "SELECT @@version;" are:
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)
The SQL Server CSE finished processing the 2450 components in just over 13 hours (per the log file gencd1.01)
Based on the above result and the fact that the customer has been using their 8.5 Oracle CSE for several years it appears to be well-tuned by their Oracle DBAs and the 8.5 Oracle CSE performance of 10 hours is close to optimum for the whole model generation.
However, the 8.6 SQL Server performance of 18 hours does seem to have a problem.
This Gen Community thread on "CSE Performance insufficient" includes SQL Server performance advice:
The customer is still progressing with other hardware and DB options as they are not satisfied with the performance.
Another factor that has been found in the past for performance degradation on a CSE (from previously good performance) is antivirus/virus protection software.