Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Network Performance Monitor (NPM) > Implications of Last Database Sync and Last Database Update values

Implications of Last Database Sync and Last Database Update values

Table of contents
Created by Daniel Polaske, last modified by Tiarnan Stacke on Nov 03, 2017

Views: 2,068 Votes: 1 Revisions: 4


This article briefly describes the logic behind the Last Database Sync and Last Database Update values in the Polling Engines page within Orion Settings.



All versions of Orion products


  • Last database Update - this is the last time data was written to the database. Any time we write data to the database, this automatically resets.
  • Last database Sync - this is a routine/query that is executed from the dataprocessor service. It’s a long query but the summary of it is it updates the KeepAlive, element counts, and polling completion fields of the AllEngines table if any (node or interface or volume)WITH(NOLOCK) exists for the engine it is assigned to. The key is it is updating the element counts. The intent is to ensure that our Core Business Layer can communicate with the database.

These two values are exclusive of each other and updated differently. A comparison between the two will not yield any useful information as one checks to see if a specific service can talk to the database, the other is reporting that the database was updated. The database can easily be updated by another one of our services. The Database Sync is only 1 service (Core Business) that is updating specific fields. The value reported is the counter of the last time those fields were updated.


Troubleshooting will start differently because the values are updated in 2 different ways. However, because it could all come back to database it is possible that the same thing could cause both of those values to rise. There are many possible causes for both of those values to be vastly different from each other.


If one of the times is always a set period of time behind (For example, Last Database Update 5 minutes ago) then this is most likely caused by a time difference between the primary Orion Server and the SQL Server. To resolve this, align the time zones of the SQL Server and all Orion Server.


Last modified