Overview
When you change attributes of a single computer or a group there are long delays while the writes to the backed database are completed.
This article provides information about possible root causes and how to address the issue.
Diagnosis
All the Attributes are stored along with other per computer or per computer group settings in the LNSSScanresultsXX database ComputerSetting table. There are several possible root causes for the latency when updating attributes on computers, most of them are related to the missing requirements or the environment.
Solution
-
Check the minimum requirements for your network size and take into consideration the additional requirements of the other applications and roles that the server running the GFI LanGuard may have. Ensure that enough hardware resources are allocated - the lack of CPU or memory capacity, heavy I/O contention severely impact the operations. Performance Monitor for Windows or similar monitoring tools can help to find out the bottlenecks.
Also, for larger deployments, we recommend using Microsoft SQL Server full version instead of the Express edition for the performance boost and to avoid hitting the database size limits.
-
Ensure necessary anti-virus exclusions according to the Recommended Settings for Best Performance in the GFI LanGuard article.
-
Perform the SQL Server settings tuning.
-
If you are not using the latest GFI LanGuard version, upgrade LanGuard.
Testing
Add/change the attributes for a computer and verify that the operations perform faster.
Related Articles