Following our NTA 4.1.2 upgrade, I have noticed intermittent slow downs of the web console. Sometimes resource throw errors (Cannot load resource ID x), load continuously or don't load at all. Most of the time it can be fixed with a refresh of the page. I went through OrionWeb.log and noticed this entry many times. Are you able to tell what it is doing? Is there a way to clean this up? We are running 11.5.2. I have no idea why an NTA upgrade from 4.1.1 to 4.1.2 would cause these issues.
Thanks
2016-09-12 14:18:40,355 [50] WARN SolarWinds.InformationService.Contract2.InfoServiceProxy - Support! -- LONG RUNNING QUERY: 16930.2902 ms: SELECT DISTINCT
m.ContainerID,
m.DisplayName AS Name,
m.Status,
m.MemberPrimaryId,
m.MemberUri,
m.MemberEntityType,
m.MemberAncestorDisplayNames,
m.MemberAncestorDetailsUrls,
e.DisplayName AS EntityName,
e.DisplayNamePlural AS EntityNamePlural
FROM Orion.ContainerMembers m
JOIN Orion.Groups g ON g.ContainerID = m.ContainerID
JOIN Metadata.Entity e ON m.MemberEntityType = e.FullName AND m.Status = 2
ORDER BY m.DisplayName RETURN XML RAW