Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Network Performance Monitor (NPM) > Long load time on Node Details view due to SWQL queries

Long load time on Node Details view due to SWQL queries

Updated 5th June 2018

Overview

The Node Details page takes long to load due to SWQL queries running in the background. The queries are related to Switch Stacks, although no Cisco Switch Stacks are monitored.

Queries causing the issue:

technologyPollingId=NPM.Node.SwitchStack

The Hubble web server response analyzer shows that database time is 80-95%.

Environment

Cause 

The issue is caused by NPM.Node.SwitchStack, that has dozens of extra SWQL statements all 100-300 ms, and thus causes the extra load.

 

Hubble showed: NPM.Node.SwitchStack.  For more information about Hubble, see Turn on Hubble.

46 306.77 Web SWQL  
SELECT TOP 1 InstanceID FROM Orion.TechnologyPollingAssignments
WHERE TechnologyPollingID = @technologyPollingId                       
AND TargetEntity = @targetEntity AN InstanceID = @nodeId                         
AND Enabled = True RETURN XML RAW (nodeId=599, technologyPollingId=NPM.Node.SwitchStack, targetEntity=Orion.Nodes)

Resolution

Upgrade to the latest versions.
This is resolved in NPM 12.3 \ Core 2018.2

 

Also to resolve the issue, can use the following workarounds:

Copy the Node Details view and reassign it to your nodes

  1. Click Settings > All Settings > Manage Views, and use the Node Details view as a template for creating a view.
  2. Set all nodes to use the copy of the original node details through Settings > All Settings > Views by Device Type.

The issue should be resolved.

Delete the Switch Stack subview

  1. On the Node Details view, click the pencil icon > Page Settings.
  2. In the Left Navigation area, delete the Switch Stack subview.image.png

Loading the Node Details view should be faster, for example instead of 10 seconds, the load time should be down to 0.8 seconds.

 

 

 

Last modified

Tags

Classifications

Public