Gen Windows SQL Server CSE slow model generation performance

Products

• Gen

Issue/Introduction

Currently upgrading to 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.

Current

• Microsoft Windows Server 2012 R2
• Dual code Intel Xeon CPU E5-2637 @ 3.5GHz
• 256 GB RAM
• Oracle 12
  
  

New

• 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.

Environment

Gen Client Server Encyclopedia

Resolution

Support obtained a copy of the user'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 are installed.
• The database is completely untuned i.e. Out Of The Box installation.
• The Object Cache is set to 1 million i.e. 1000000
• The CSE only has the user'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 user 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: CSE Performance insufficient

Additional Information

1. The user is still progressing with other hardware and database options as they are not satisfied with the performance.
   
   
2. Another factor that has been found in the past for performance degradation on a CSE (from previously good performance) is antivirus/virus protection software.