KSC Slow After installing

[Lepi.nrc]

Hi All,

i install KSC 14.2 on windows 2022 data center and after in add key file .its slow in any selection. when i open new mmc & click on manged device its  so slowly & lock . after that i shoud close it with task manager.

please say me how can i solve it? my server  have   9 core cpu  and 8GB of ram. 

[ElvinE5]

I can assume that SQL 2019 is selected as the database... in this case you need to fulfill some additional conditions

https://support.kaspersky.com/KSC/14.2/en-US/92403_1.htm

 

If you are using SQL Server 2019 as a DBMS and you do not have cumulative patch CU12 or later, you have to perform the following after installing Kaspersky Security Center:

1. Connect to SQL Server using SQL Management Studio.
2. Run the following commands (if you chose a different name for the database, use that name instead of KAV):

   USE KAV

   GO

   ALTER DATABASE SCOPED CONFIGURATION SET TSQL_SCALAR_UDF_INLINING = OFF

   GO

3. Restart the SQL Server 2019 service.

Otherwise, using SQL Server 2019 may result in errors, such as "There is insufficient system memory in resource pool 'internal' to run this query."

[Danijel Jovanovic JAPICOM]

Just to add that this problem is not happening with SQL 2022. I know that SQL 2022 is not listed in software requirements, but i did couple installations of KSC with SQL 2022 and everything works without this procedure.

[Demiad]

@Danijel Jovanovic JAPICOM hello.

Unfortunately, you may be rejected when you request support.

[Danijel Jovanovic JAPICOM]

@Demiad

Hi, i know. I never deployed it like that in production, just for testing. 

Since my last post i tested it with multiple KSC on one sql server, tested KSC with sql express and standard and tested KSC in failover with sql 2022, everything works without any problem.