Significant performance issues may affect reconcile time, especially during the ApplicationsByFileEvidence step, when using FlexNet Manager Suite with SQL server 2019.
A new install of FlexNet Manager Suite with a set of demo data and SQL 2019 in default compatibility mode was measured to take over 3 hours to complete reconcile, with the ApplicationsByFileEvidence step taking over two hours to complete. Once the compatibility mode was set to 2012, subsequent reconcile completed in 12 minutes.
Set the SQL database compatibility mode to 110 (SQL 2012). See View or change the compatibility level of a database for assistance.
This issue is still open but not currently scheduled to be addressed.
Affected components: Database, Inventory import (read/write/export)
Master issue ID: IOK-703164
Also known as: ITAM-664