Following an upgrade from Symantec Endpoint Protection Manager (SEPM) 12.1.7454.7000 (schema version 12.1.6.11) to 14.2.1023.0100 (schema version 14.2.0.2), you see excessive CPU utilization on the SQL Server.
Error in AgentSecurityLogCollector-0.log
2019-03-08 08:14:04.513 THREAD 135 WARNING: SQLException: BCP data error:
Starting copy...
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Server Native Client 11.0]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Server Native Client 11.0]String data, right truncation
0 rows copied.
Environment using SEPM 14.2 MP1 with SQL database and application learning enabled.
This issue is fixed in version 14.2 RU1 MP1 by adding type conversion to the SQL statement to prevent this performance issue.
For information on how to obtain the latest build of Symantec Endpoint Protection, read
TECH103088: Download the latest version of Symantec Endpoint Protection