Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > Alternative for the Node Availability Resource

Alternative for the Node Availability Resource

Overview

This article explains an alternative solution for the Node Availability resource in cases when it times out or takes a long time to load.

Environment

All NPM versions

Cause 

The nodes availability resource could take a long time to load the page. This is usually caused by volume of statistics to load on all nodes or the SQL is not performing as it should.

Helpful Alternative

  1. Create a custom table resource on any page. 
  2. Select Data Source.
  3. Click Selection Method: Advanced DataBase Query (SQL, SWQL).
  4. Modify the query to include any type of Group by selectors such as a custom property. See the following example below:
    Note: SolarWinds Support cannot help modify this query to include a group by your choice:

SELECT 
ROUND(SUM((CASE WHEN [data].[ResponseTimeHistory].[Availability] < 0 THEN NULL ELSE [data].[ResponseTimeHistory].[Availability] END)*(data.ResponseTimeHistory.Weight))/SUM(case when ((CASE WHEN [data].[ResponseTimeHistory].[Availability] < 0 THEN NULL ELSE [data].[ResponseTimeHistory].[Availability] END) is null) then 0 else (data.ResponseTimeHistory.Weight) end),3) AS [Last 30 Days] 
FROM Orion.Nodes AS data 
WHERE NodeID = ${NodeID} 
AND ToString(DayDiff(ToLocal([data].[ResponseTimeHistory].DateTime),GETDATE())) <= 30 

 

If the issue is in Custom Query resources, SolarWinds recommends to include paging capability. And this takes first column and it wasn't parsed well. 

If the paging scalability is not the first column, add some dummy column as the first column in query, which will simulate paging.

SELECT '${Caption}' as Caption,
((SELECT 
ROUND(SUM((CASE .....

Last modified

Tags

Classifications

Public