anyone know what causes this event message flood?
An Exception was thrown while updating the DNS cache.
Error Detail-Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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.
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
