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

Node Page Slow

Just started today not sure if someone added a new resource to the node detail page. Solarwinds do you know what resource or why the query is run. Also its taking 15 seconds to run. Still investigating why the query is slow

15281.06

Web

SWQL

SELECT COUNT(hvs.HardwareItemID) as cnt
FROM Orion.APM.HardwareItem hi
INNER JOIN Orion.APM.HardwareCategoryStatus hcs ON hcs.ID = hi.HardwareCategoryStatusID
INNER JOIN Orion.APM.HardwareItemValueStatistics hvs ON hi.ID = hvs.HardwareItemID
WHERE hi.NodeID = NodeId
    AND hcs.HardwareCategoryID = CategoryId
    AND hi.Unit = UnitId 
    AND hvs.AvgValue IS NOT NULL RETURN XML RAW (NodeId=10300, CategoryId=4, UnitId=2)

Find more posts tagged with

Accepted answers

All comments

bwicks

Looks like this query is related to the Health Chart for Temperature. We removed the resource. Solarwinds might want to check out the query for the resource.

martin.susil

Thank you for reporting of this issue. Development team will investigate what can be done to improve it.