data_engine and queue management tips

Products

• DX Infrastructure Management
• NIMSOFT PROBES

Issue/Introduction

Some tips and techniques for data_engine settings and queue management

 

 

Environment

Release: CNMSPP99000-8.4-Unified Infrastructure Mgmt-Server Pack-- On Prem
Component:

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:

<Please see attached file for image>

 

 

 

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