Follow the guidelines below to ensure data integrity:
If you installed anti-virus software on the management console server, exclude all NetQoS directories from real-time and scheduled scans to avoid database corruption.
If you configured your environment to push rules from a centralized anti-virus system, add a rule to exclude the following directories from scans:
• C:\Windows\Temp
• D:\NETQOS (or the directory where CA Application Delivery Analysis is installed) and all subdirectories.
Automated backups can corrupt the database if the backup locks the database during a data write operation. If this occurs, manually restore the database.
The management console does not support drive space compression. The benefit of greater drive space is not worth possible loss of the database or degrading system performance. See the Microsoft Knowledge Base Article SQL Server databases not supported on compressed volumes for more information. The compression-related issues discussed in this article are also applicable to MySql databases.
