14 Replies Latest reply on Sep 23, 2016 10:03 AM by jxchappell

    Intermittent Slowdowns in Web Console

    bharris

      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