Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Slow Response Time On NTA Summary Page

My NTA Summary page is taking forever to load. I turned on huddle and saw the following. I have attached the top 3 longest running queries. This query is being run 162 times (matching the number of devices configured to send Netflows. What is this query doing? Can it be disabled?

Database Time:	115441 ms	99.0 %
Business Layer Time:	-8 ms	-0.0 %
Other Time:	1164 ms	1.0 %
Total Time:	116597 ms	100.0 %

View State Size:	0 KB
Stylesheet Count:	28

Time (ms)

Origin

Type

Warnings

SQL

799.51

Web

SWQL

Possible SELECT N+1. This exact query is executed 162 times with different parameters. Consider combining these queries into a single query.

SELECT Node.PCUs.FirmwareVersion FROM Cortex.Orion.Node Node WHERE Node.PCUs.PollState <> pollstate AND NodeId = nodeid RETURN XML RAW (pollstate=3, nodeid=2150)

Show Stacktrace

142

796.96

Web

SWQL

SELECT Node.PCUs.FirmwareVersion FROM Cortex.Orion.Node Node WHERE Node.PCUs.PollState <> pollstate AND NodeId = nodeid RETURN XML RAW (pollstate=3, nodeid=2186)

Show Stacktrace

148

793.08

Web

SWQL

SELECT Node.PCUs.FirmwareVersion FROM Cortex.Orion.Node Node WHERE Node.PCUs.PollState <> pollstate AND NodeId = nodeid RETURN XML RAW (pollstate=3, nodeid=2189)

Show Stacktrace

Find more posts tagged with

Accepted answers

All comments

alphabits

What version of NTA are you running, and which resources do you have on the NTA Summary page?

donrobert5

check the NTA version. It might be a known issue for that version. You can also check the link below.

Success Center

mesverrum

You should edit the page settings for that view and double check what resources you have on the page. If you see anything that might have a name with anything relating to pcu/power then go ahead and remove those widgets from the view, I wouldn't expect an NTA vew to need any of those widgets and those are the ones that make those calls. I want to say the first version that released with those widgets they were very slow, but the problem may have been fixed in a more recent release, but I am not sure because I just got into the habit of removing those widgets because they were hurting my load times so much.

bharris1

This is what is on there. Nothing about PCU/power.

mesverrum

Strange, a way you can debug which widget is causing the pain is to add another tab to the view and move the widgets to the second tab one by one until your page stops generating those queries.

Try detach each resource and measure it independently via Hubble. Maybe it's some child status calculation.

bharris1

It looks like it is the Netflow Sources resource. Once I removed it, the page loaded quickly and the Hubble entries that I listed above were gone. I tried to readd it and the super long load times returned as well as the hubble entries with the PCU warranty calls..

bharris1

Neither of these links are the problem we are seeing.