Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Check if Nodes are Polling Data using Database Manager

Check if Nodes are Polling Data using Database Manager

Table of contents
Created by Jousseff Jaranilla, last modified by MindTouch on Jun 23, 2016

Views: 2,057 Votes: 2 Revisions: 10

Overview

The following procedure executes the required SQL Command to check if Nodes are polling data using Database Manager.

Environment

  • NPM 11.0.1 and Lower Version

  • NPM 11.5 and Higher Version

Steps

Note: LastSync and NextPoll should match the information found on the Orion Web Console.

NPM 11.0.1 and Below Version

1. On your Windows Server, search for Database Manager

2. Click on Add Default Server

3. Right-click on your SolarWindsOrion Database

4. Select New Query

5. Paste the query below:

SELECT NodeID, LastSync, NextPoll FROM [dbo].[Nodes]

NPM 11.5 and Higher Version

1. On your Windows Server, search for Database Manager

2. Click on Add Default Server

3. Right-click on your SolarWindsOrion Database

4. Select New Query

5. Paste the query below:

SELECT NodeID, LastSync, NextPoll FROM [dbo].[NodesStatistics]

 

Last modified

Tags

Classifications

Public