12 Replies Latest reply on Aug 13, 2019 8:15 AM by bharris

    Slow Response Time On NTA Summary Page

    bharris

      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 ms99.0 %
      Business Layer Time:-8 ms-0.0 %
      Other Time:1164 ms1.0 %
      Total Time:116597 ms100.0 %
      View State Size:0 KB
      Stylesheet Count:

      28

      #Time (ms)OriginTypeWarningsSQL
      24799.51WebSWQL
      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
      142796.96WebSWQL
      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
      148793.08WebSWQL
      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