syslog question

This error means that your database is processing too slowly the update DNS request for the Syslog messages or that Orion is requesting too much entries to be updated.

1) You can firstly increase the SQL Query Timeout.

Edit the \Program Files\Solarwinds\Orion\SWNetPerfMon.db

and modify at the bottom of it the CommandTimeout:

! ! Database Command timeout in seconds CommandTimeout=xx

to something higher such as 180 seconds.

Restart the services

Start > All Programs > Solarwinds Orion > Advanced Features > Orion Service Manager

Shutdown Everything and then Start Everything.

If you keep having the error message, try to increase again this variable and try the 2), 3) and 4) steps.

2) You can reduce the number of Syslog Messages that have to be processed.

Start > All Programs > Solarwinds Orion > Syslog Viewer

File > Settings

Decrease the "Retain Syslog Messages for how many days ?" value in the general tab.

Click on ok.

3) Truncate the table if you do not need to keep historical syslog messages

Open Database Manager

Start > All Programs > Solarwinds Orion > Database Utilities > Database Manager

If this is the first time you use the tool, add your database server by clicking on the Add server button.

Expand your database and right-click on the SysLog table.

Select Query Table.

Type the below SQL query:

TRUNCATE TABLE SysLog

and click on Refresh to execute the query.

This may take a while depending how many entries are recorded.

Once done, right-click on the database and select Compact Database.

Compacting a database shrinks it, reindexes it, and removes whitespace.

4) You can increase the DNS cache lookup interval by editing a database value.

Open Database Manager

Expand your Orion database

Right-Click on the Settings table and select Query Table.

Select "Read-Write (Results can be edited)"

Click on Refresh

Increase the "CurrentValue" field of the "SysLog Service - DNS Cache Time" entry.

Ensure the new value has been written by refreshing the contents once more.

Hope that helps.

 Yann