Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

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 MindTouch on Jun 23, 2016

Views: 278 Votes: 1 Revisions: 3

Overview

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

 

Environment

All versions of Orion products

Detail

  • 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.

 

Last modified
22:29, 22 Jun 2016

Tags

Classifications

Public