data_engine and queue management tips

book

Article ID: 33539

calendar_today

Updated On:

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>

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

Attachments

1558689800698000033539_sktwi1f5rjvs16g29.png get_app
1558689797732000033539_sktwi1f5rjvs16g28.png get_app