Hi
When i am using solarwinds web console, i found some of the applications taking too long to run. So as i bad response in webconsole i went back to have a look at orion database. So when i see database i found a QUERY taking very long to execute and kept on waiting which is holding up tasks in database and creating more latency.
The query below is running since 10days and i found now it is because of this query lot of tasks got hold up. Let me know what is the query and how to fix it to resolve my issue.
This issue is causing me since i updgraded my ORION platform.
(@snmpV3SettingName nvarchar(18))
SELECT ObjectSubType,
UnManaged,
nip.NodeID,
nip.IPAddress,
EngineID,
DNS,
SNMPVersion,
ns.SettingValue as SNMPV3CredId
FROM NodeIPAddresses nip
WITH
(
NOLOCK
)
INNER JOIN Nodes n
WITH
(
NOLOCK
)
ON n.NodeID = nip.NodeID
LEFT JOIN dbo.NodeSettings ns
WITH
(
NOLOCK
)
ON n.NodeID = ns.NodeID
AND ns.SettingName = @snmpV3SettingName
WHERE 1=1
AND [ObjectSubType] <> 'Agent'
UNION
SELECT ObjectSubType,
UnManaged,
n.NodeID,
IP_Address,
EngineID,
DNS,
SNMPVersion,
ns.SettingValue as SNMPV3CredId
FROM Nodes n
WITH
(
NOLOCK
)
LEFT JOIN dbo.NodeSettings ns
WITH
(
NOLOCK
)
ON n.NodeID = ns.NodeID
AND ns.SettingName = @snmpV3SettingName
WHERE 1=1
AND [ObjectSubType] <> 'Agent'
