data_engine and queue management tips

Document ID : KB000033539
Last Modified Date : 19/02/2019
Show Technical Document Details
Issue:

Some tips and techniques for data_engine settings and queue management

 

 

Resolution:
Disable on-access/real-time virus scanning against Nimsoft SLM's data and transaction log files

Disable on-access/real-time virus scanning against at least following NImsoft folders/directories:
$NIMROOT\hub\q
$NIMROOT\probes\service\nas

where $NIMROOT is Nimsoft install location

Nimsoft SLM database files should be on separate disk and controller from the Nimsoft software. For MS SQL Server, data and transaction log files should be on separate disks and separate from any other databases, particularly the tempdb database.

For MS SQL Server, the following database options should be set:

Auto create statistics = true
Auto create statistics asynchronously = true
Aut update statistics = true
Auto close = false
Auto shrink = false


As shown here in MS SQL Server Management Studio:

SQLDatabaseProperties.png


 
 


 
Additional Information:
Please also refer to the following link for information on directories to exclude:
TEC000003358
Anti-Virus Protection and Nimsoft
http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec000003358.aspx