Improve KSC Console performance by adding “Missing Indexes”

[ak01]

I had the issue that KSC MGMT Console (12.0.0.7734 and Patch A) was sometimes very slow. Sometimes, when I clicked through wizards, the wizard hang for a few seconds (but not always at the same position, it was always on different positions).

 

I did some research on MSSQL Tuning and found a Maintenance Plan https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/use-the-maintenance-plan-wizard?view=sql-server-ver15

However, doing a Reindex (as explained) helped a bit but did not solve my issue. However, it seems that this Maintenance Plan cannot be used at MSSQL Express (but the SQL Transactions can be executed separately).

 

In MSSQL Studio, I found a Performance Report, which states that there are about 100 missing indexes (by clicking on “Missing Indexes”, MSSQL Studio provides a list of suggested Indexes to add to improve performance):

 

 

 

According to https://docs.microsoft.com/en-us/sql/relational-databases/performance/performance-dashboard?view=sql-server-ver15, when the score is above 100000, it could be sufficient to add these Indexes.

 

I added about 25 Indexes, which had the highest score values and this significantly improved KSC Console performance. It also decreased CPU consumption.

 

It would be interesting for me, if this is supported?

For me, that improved the performance. Maybe Kaspersky could add such features to the next KSC version (adding more indexes than already automatically applied).

 

What does the KSC database maintenance task do exactly? Does it do a Reindex anyway?

[ak01]

Is “adding indexes to the KSC database” supported?

The cpu is now under 20% (mostly) and the mmc reacts much faster.