data_engine and queue management tips

Document ID : KB000033539
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary: 

Some tips and techniques for data_engine settings and queue management

Environment:  

Any

Instructions:

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