7 Replies Latest reply on Sep 4, 2015 7:52 AM by david.speer

    What is the root cause of intermittent sluggishness, especially when viewing node details in the Web Interface?

    david.speer

      Version:

      Version.PNG

       

      Question:

      What is the root cause of intermittent sluggishness, especially when viewing node details in the Web Interface?

       

      Issue:

      During some operations the web console slows down and in some cases times out all together.

      .At times the solution is to load another browser session on the client.

      Sometimes when this happens the resolution is to restart the web front end - SQL is off box.

       

      Symptoms:

      The place I notice it most is when viewing node details or monitor details.

      Other view loading, template building views have the behavior.

       

      Resources:

      Both are virtual machines on a 2012 R2 HyperV.

      Other machines are not starving the nodes in question.

       

       

      Our SQL server has an appropriate memory profile.

      SQLMemory.PNG

       

      Polling engines:

      PollingEngine.PNG

       

      Disk Queue Length:

      From SQL during a request for node details, E: is the SQL database volume. Raid 5 - 8 physical disks.

      NodeDetails.PNG

       

      CPU Utilization - SQL:

      SQLCPU.PNG

      CPU Utilization - Web Front End:

      WebFrontEndCPU.PNG

      Virtual Host CPU/Memory: (Note hardware status is healthy for the host, always)

      VirtualHostCPU_Memory.PNG

        • Re: What is the root cause of intermittent sluggishness, especially when viewing node details in the Web Interface?
          Jeff Catlin

          You may want consider enabling hubble using the log adjuster and providing that data to give us a better idea of what may be causing the issue as well.

            • Re: What is the root cause of intermittent sluggishness, especially when viewing node details in the Web Interface?
              aLTeReGo

              I would also recommend the following the steps below, as well as those outline in this KB article -> http://knowledgebase.solarwinds.com/kb/questions/5187/

               

                              1) Stop All the Orion Services

                              2) Delete ASP.NET cached files from

                                              c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files  and

                                              c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files

                              3) Re-run the Configuration Wizard with just Website configuration

                • Re: What is the root cause of intermittent sluggishness, especially when viewing node details in the Web Interface?
                  david.speer

                  I've performed the 3 steps.

                  Hubble.PNG

                  Hubble Detail:

                   

                   

                   

                     DOMAIN\DAVID.SPEER (LOGOUT) Settings

                  HOME

                  NETWORK

                  NETFLOW

                  APPLICATIONS

                  VIRTUALIZATION

                  WEB

                  Home Top 10WorldMapQuality of ExperienceGroupsEventsAlertsSyslogOverviewReportsMessage CenterAdminLogoutCustom SummaryHelpTrainingVirtualizationDatabases

                  Export to PDF Customize Page

                  Tuesday, 30 June 2015 13:39:19

                   

                   

                  Virtualization SummaryUSVS15

                  Web Browse to EXTSPWFE03Open a Secure Shell (SSH) session to EXTSPWFE03Open a Telnet session to EXTSPWFE03Launch SolarWinds PING toolLaunch SolarWinds TraceRoute toolOpen a Remote Desktop session to EXTSPWFE03 Node Details -  Status EXTSPWFE03 - Virtual Machine hosted by USVS15 - Summary

                   

                  Summary

                   

                  Vital Stats

                   

                  Network

                   

                  Asset Inventory

                   

                  Add tab

                   

                   

                  HELP EDITTHRESHOLDS

                  Average Response Time & Packet Loss

                   

                   

                    

                   

                   

                  HELP EDITTHRESHOLDS

                  Average CPU Load & Memory Utilization

                   

                   

                    

                   

                   

                  HELP EDIT

                  Management

                  NODE

                  Edit Node   List Resources   Unmanage   Poll Now   Rediscover  Add New Alert   Service Control Manager   Real-Time Event Log Viewer

                   

                   

                  HELP EDIT

                  Node Details

                   

                    Node Status Node status is Up.

                  Node is Up.   

                    Polling IP Address 10.0.8.193

                    Dynamic IP No

                    Machine Type Windows 2012 Server

                    DNS EXTSPWFE03

                    System Name EXTSPWFE03

                    Description Hardware: Intel64 Family 6 Model 44 Stepping 2 AT/AT COMPATIBLE - Software: Windows Version 6.2 (Build 9200 Multiprocessor Free)

                    Location Default-First-Site-Name

                    Contact 

                    SysObjectID 

                    Last Boot Sunday, May 24, 2015 12:31 PM

                    Software Version 6.2 (Build 9200 Multiprocessor Free)

                    Software Image Unknown

                    Hardware Virtual hosted by USVS15

                    No of CPUs 4

                    Telnet telnet://10.0.8.193

                    Web Browse http://10.0.8.193

                   

                  HELP EDIT

                  Event Summary

                   

                   

                  HELP EDIT

                  All IP Addresses on EXTSPWFE03

                   

                   

                  IP VERSION IP ADDRESS

                  IPv4 10.0.8.193 (polling IP)

                  IPv4 10.0.8.168

                  IPv4 10.0.8.169

                  IPv4 10.0.8.170

                  IPv4 10.0.8.173

                  |   Show all

                   

                   

                  HELP EDIT

                  Polling Details

                    Polling IP Address 10.0.8.193

                    Polling Engine USORIONWEB01 (10.0.6.33)

                    Polling Method: WMI

                    Polling Interval 120 seconds

                    Next Poll 01:37 PM

                   

                    Statistics Collection 5 minutes

                    Enable 64 bit Counters Yes

                   

                    Rediscovery Interval 30 minutes

                    Next Rediscovery 02:04 PM

                   

                    Last Database Update Tuesday, June 30, 2015 1:36 PM

                   

                   

                  HELP EDIT

                  Availability Statistics

                  PERIOD AVAILABILITY

                  Today 100.000 %

                  Yesterday 97.639 %

                  Last 7 Days 99.687 %

                  Last 30 Days 99.922 %

                  This Month 99.919 %

                  Last Month 100.000 %

                  This Year 99.951 %

                   

                   

                  HELP EDIT

                  Top 5 Conversations (Endpoint Centric)

                  BOTH, LAST 12 HOURS, RATE (KBPS)

                  3:00 AM

                  6:00 AM

                  9:00 AM

                  12:00 PM

                  0 bps

                  2.5 Mbps

                  5.0 Mbps

                  7.5 Mbps

                  10.0 Mbps

                  8:00 AM

                  CONVERSATION INGRESS

                  BYTES EGRESS

                  BYTES INGRESS

                  PACKETS EGRESS

                  PACKETS PERCENT

                    Conversation Between 10.0.3.189 and 10.0.8.193 0 bytes 3.5 Gbytes 0 7.33 M 50.65%

                    Conversation Between 10.0.3.188 and 10.0.8.193 0 bytes 3.3 Gbytes 0 3.34 M 47.46%

                    Conversation Between ussql63.DOMAIN.org (10.0.3.114) and 10.0.8.193 0 bytes 98.7 Mbytes 0 221.35 k 1.44%

                    Conversation Between usbalprxy01.DOMAIN.org (10.0.6.20) and 10.0.8.193 0 bytes 23.9 Mbytes 0 39.24 k 0.35%

                    Conversation Between USORIONWEB01.DOMAIN.org (10.0.6.33) and 10.0.8.193 0 bytes 2.4 Mbytes 0 8.37 k 0.04%

                  Remaining traffic 0 bytes 4.0 Mbytes 0 13.9 k 0.06%

                   

                   

                  HELP EDIT

                  AppStack Environment for EXTSPWFE03

                  GROUPS (2)11

                  APPLICATIONS (0)

                  TRANSACTIONS (0)

                  STEPS (0)

                  SERVERS (1)1

                  HOSTS (1)1

                  VIRTUAL CLUSTERS (0)

                  VIRTUAL DATACENTERS (0)

                  VIRTUAL CENTERS (0)

                  DATA STORES (0)

                  VOLUMES (5)5

                  LUNS (0)

                  NAS VOLUMES (0)

                  POOLS (0)

                  VSERVERS (0)

                  STORAGE ARRAYS (0)

                  » View in Entire AppStack Environment

                   

                   

                  HELP EDIT

                  Multiple Interfaces Chart

                  GRAPH MULTIPLE INTERFACES

                  On a single chart, graph the same type of data for multiple network objects.

                  Graph network objects individually, or sum values for selected network objects.

                   

                   

                  A chart has not been selected for this resource.

                  Select objects for this resource.

                  Click Edit in the resource header at any time to configure this resource further.

                  » Configure this resource

                   

                   

                  HELP EDITEXPORT

                  Average Response Time & Packet Loss

                  Zoom

                  RESPONSE TIME IN MILLISECONDS

                  EXTSPWFE03

                  May 31 2015, 1:00 pm - Jun 30 2015, 1:30 pm

                  1 Jun

                  15 Jun

                  29 Jun

                  8 Jun

                  22 Jun

                  0 ms

                  1 ms

                  0.25 ms

                  0.5 ms

                  0.75 ms

                  1.25 ms

                  1.5 ms

                  1 Jun

                  8 Jun

                  15 Jun

                  22 Jun

                  29 Jun

                  1h

                  12h

                  24h

                    Response Time EXTSPWFE03

                    Percentile 95%

                   

                   

                   

                   

                  HELP EDITEXPORT

                  Min/Max/Average of Average CPU Load

                  Zoom

                  AVERAGE CPU LOAD

                  EXTSPWFE03

                  Jun 23 2015, 12:00 am - Jun 30 2015, 1:30 pm

                  29 Jun

                  23 Jun

                  24 Jun

                  25 Jun

                  26 Jun

                  27 Jun

                  28 Jun

                  30 Jun

                  0 %

                  100 %

                  25 %

                  50 %

                  75 %

                  125 %

                  1 Jun

                  8 Jun

                  15 Jun

                  22 Jun

                  29 Jun

                  1h

                  12h

                  24h

                    Average CPU Load EXTSPWFE03

                    Percentile 95%

                    Min/Max CPU Load EXTSPWFE03

                   

                   

                   

                   

                  HELP EDITEXPORT

                  Top CPUs by Percent Load

                  Zoom

                  CPU LOAD

                  EXTSPWFE03

                  Jun 29 2015, 1:00 pm - Jun 30 2015, 1:30 pm

                  30 Jun

                  12:00 PM

                  4:00 PM

                  8:00 PM

                  4:00 AM

                  8:00 AM

                  0 %

                  100 %

                  25 %

                  50 %

                  75 %

                  125 %

                  4:00 PM

                  30 Jun

                  8:00 AM

                  1h

                  12h

                  24h

                    CPU Load EXTSPWFE03 - CPU # 1

                    CPU Load EXTSPWFE03 - CPU # 2

                    CPU Load EXTSPWFE03 - CPU # 3

                    CPU Load EXTSPWFE03 - CPU # 4

                   

                   

                   

                   

                  HELP EDIT

                  Current Percent Utilization of each Interface

                    STATUS INTERFACE TRANSMIT RECEIVE 

                    Up Microsoft Hyper-V Network Adapter · Ethernet

                   

                   

                    0 %

                   

                   

                    0 % Launch SolarWinds Real-Time Bandwidth Gauges

                   

                   

                  HELP EDIT

                  CPUs by Percent Load

                  CPU NAME PERCENT LOAD

                  CPU # 3 76 %

                   

                   

                   

                  CPU # 1 70 %

                   

                   

                   

                  CPU # 2 52 %

                   

                   

                   

                  CPU # 4 35 %

                   

                   

                   

                    Prev 20 Next 20   Show All

                   

                   

                  HELP EDIT

                  Disk Volumes

                    VOLUME SIZE SPACE USED 

                    C:\ Label: 96BD6D5A 119.7 GB 45.6 GB 38 %

                   

                    E:\ Label:Logs DEE44F2C 80.0 GB 10.6 GB 13 %

                   

                    Physical Memory 24.0 GB 15.2 GB 63 %

                   

                   

                  HELP EDITALL ACTIVE ALERTS

                  Active Alerts on This Node (0)

                  ALL UNACKNOWLEDGED ALERTS

                  ALERT NAME MESSAGE TRIGGERING OBJECT ACTIVE TIME RELATED NODE

                   

                   

                  HELP EDITEXPORT

                  CPU Capacity Forecast Chart

                  Zoom

                  PERCENT LOAD

                  EXTSPWFE03

                  $[ZoomRange]

                  Feb '15

                  Mar '15

                  Apr '15

                  May '15

                  Jun '15

                  0.00 %

                  100.00 %

                  25.00 %

                  50.00 %

                  75.00 %

                  125.00 %

                  Mar '15

                  May '15

                  1h

                  12h

                  24h

                  RESOURCE TREND SLOPE WARNING CRITICAL AT CAPACITY

                  Peak Trend 0.59% / day >80%

                  Now >90%

                  Now >100%

                  Now

                  Average Trend 0.51% / day >80%

                  6 weeks >90%

                  2 months >100%

                  2 months

                   

                   

                   

                   

                  HELP EDITEXPORT

                  Memory Capacity Forecast Chart

                  Zoom

                  PERCENT LOAD

                  EXTSPWFE03

                  $[ZoomRange]

                  Feb '15

                  Mar '15

                  Apr '15

                  May '15

                  Jun '15

                  0.00 %

                  50.00 %

                  25.00 %

                  75.00 %

                  100.00 %

                  Mar '15

                  May '15

                  1h

                  12h

                  24h

                  RESOURCE TREND SLOPE WARNING CRITICAL AT CAPACITY

                  Peak Trend 1.35% / day >80%

                  Now >90%

                  4 days >100%

                  12 days

                  Average Trend 1.29% / day >80%

                  4 days >90%

                  12 days >100%

                  2 weeks

                   

                   

                   

                   

                  EDITADD NOTE

                  Last 5 Notes (0)

                   

                   

                   

                   

                  HELP EDIT

                  Node Resource Capacity Forecast

                  RESOURCE LAST 7 DAYS WARNING CRITICAL AT CAPACITY

                  CPU Load Avg:44%

                  -3%

                  >80%

                  6 weeks

                  >90%

                  2 months

                  >100%

                  2 months

                  Percent Memory Usage Avg:58%

                  -2%

                  >80%

                  4 days

                  >90%

                  12 days

                  >100%

                  2 weeks

                   

                   

                  HELP EDIT

                  Volume Capacity Forecast

                  RESOURCE LAST 7 DAYS WARNING CRITICAL AT CAPACITY

                  C:\ Label: 96BD6D5A Avg:38%

                  0%

                  >80%

                  7 months

                  >95%

                  10 months

                  >100%

                  11 months

                  E:\ Label:Logs DEE44F2C Avg:12%

                  0%

                  >80%

                  6 months

                  >95%

                  8 months

                  >100%

                  9 months

                  Physical Memory Avg:58%

                  -2%

                  >80%

                  4 days

                  >95%

                  2 weeks

                  >100%

                  2 weeks

                   

                   

                  HELP EDITALL AUDIT EVENTS

                  Last 5 Audit Events

                  LAST 30 DAYS

                  DATE TIME USER ACTION

                  6/22/2015 4:09:06 PM DOMAIN\joacim.karlsson changed Node's EXTSPWFE03 polling engine from USORION01 (10.0.6.33) to USORIONWEB01 (10.0.6.33)

                   

                   

                  HELP EDITEXPORT

                  Total Disk IOPS

                  Zoom

                  DISK READS

                  DISK WRITES

                  EXTSPWFE03

                  Jun 30 2015, 12:00 am - Jun 30 2015, 1:30 pm

                  12:00 AM

                  12:00 PM

                  4:00 AM

                  8:00 AM

                  2:00 AM

                  6:00 AM

                  10:00 AM

                  0

                  10

                  20

                  30

                  40

                  4:00 PM

                  30 Jun

                  8:00 AM

                  1h

                  12h

                  24h

                    Disk reads EXTSPWFE03-C:\ Label: 96BD6D5A

                    Percentile 95%

                    Disk writes EXTSPWFE03-C:\ Label: 96BD6D5A

                    Disk reads EXTSPWFE03-E:\ Label:Logs DEE44F2C

                    Disk writes EXTSPWFE03-E:\ Label:Logs DEE44F2C

                    Disk reads EXTSPWFE03-Physical Memory

                    Disk writes EXTSPWFE03-Physical Memory

                    Sum

                   

                   

                  SolarWindsOrion Platform 2015.1.2, SAM 6.2.1, DPA 9.2.0, QoE 2.0, NPM 11.5.2, NTA 4.1.1, WPM 2.2.0, IVIM 2.1.0 © 1995-2015 SolarWinds Worldwide, LLC. All Rights Reserved.2796 ms. 162 queries. 16 BL calls. 4 Warnings. 120 KB ViewState. 39 Styles » Details

                  View Cached Hubble Results

                  Database Time: 2194 ms 78.5 %

                  Business Layer Time: 91 ms 3.3 %

                  Other Time: 511 ms 18.3 %

                  Total Time: 2796 ms 100.0 %

                  View State Size: 120 KB

                  Stylesheet Count: 39

                    Duplicate query detected. This request executed the same query multiple times (with the same paramters). Consider caching the query results so that the query is only executed once.

                    Possible SELECT N+1. This request executed the same query multiple times with different parameters. This is often a sign of a N+1 problem (more details). Consider combining these queries into a single query.

                    Large View State. The View State for this requests is large. Consider using web service calls rather than posting back large amounts of data.

                    Too Many Stylesheets. There are a large number of stylesheets included on this page. Internet Explorer is limited to 31 styles per page (this includes links to external files and styles defined inline using style tags).

                  # Time (ms) Origin Type Warnings SQL

                  1 0.38 Web SQL

                  SELECT 1

                  Show Stacktrace

                  2 0.63 Web SQL Possible SELECT N+1.  This exact query is executed 2 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM Nodes WITH (NOLOCK) WHERE NodeID=@node (node=1967)

                  Show Stacktrace

                  3 0.54 Web SQL

                  SELECT * FROM Accounts WHERE AccountID=@AccountID (@AccountID=DOMAIN\david.speer)

                  Show Stacktrace

                  4 0.52 Web SQL

                  SELECT SettingName, SettingValue FROM WebUserSettings WHERE AccountID=@account  (@account=DOMAIN\david.speer)

                  Show Stacktrace

                  5 0.48 Web SQL

                  SELECT PermissionName, PermissionValue FROM APM_WebUserPermissions WHERE AccountID = @account (@account=DOMAIN\david.speer)

                  Show Stacktrace

                  6 5.65 Web SWQL

                  SELECT PermissionValue FROM Orion.SEUM.WebUserPermissions WHERE AccountID=@Account AND PermissionName=@PermissionName RETURN XML RAW (Account=DOMAIN\david.speer, PermissionName=SEUM.SEUMAllowAdmin)

                  Show Stacktrace

                  7 0.50 Web SQL

                  SELECT ServerName, BusinessLayerPort FROM dbo.Engines WITH(NOLOCK) WHERE ServerType = 'Primary' or ServerType like '%Hot-Standby%Active%' ORDER BY KeepAlive DESC

                  Show Stacktrace

                  8 0.47 Web SQL

                  Select * FROM NodeSettings WITH (NOLOCK) where NodeID = @NodeID (@NodeID=1967)

                  Show Stacktrace

                  9 0.57 Web SQL

                  SELECT ViewID FROM ViewsByDeviceType WHERE ObjectType LIKE @ObjectType AND RTRIM(DeviceType) LIKE @DeviceType (@DeviceType=Windows 2012 Server, @ObjectType=N)

                  Show Stacktrace

                  10 0.55 Web SQL Duplicate Query.  This exact query is execute 2 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT * FROM Views WHERE RTRIM(ViewType) LIKE @ViewType (@ViewType=NodeDetails)

                  Show Stacktrace

                  11 0.53 Web SQL Duplicate Query.  This exact query is execute 2 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT * FROM Views WHERE RTRIM(ViewType) LIKE @ViewType (@ViewType=NodeDetails)

                  Show Stacktrace

                  12 0.51 Web SQL

                  SELECT SettingName, SettingValue FROM WebSettings

                  Show Stacktrace

                  13 0.62 Web SQL

                  SELECT * FROM Views WHERE ViewGroup=@ViewGroup

                                                   Order by ViewGroupPosition (@ViewGroup=1)

                  Show Stacktrace

                  14 0.47 Web SQL Possible SELECT N+1.  This exact query is executed 8 times with different parameters.  Consider combining these queries into a single query.

                  SELECT Condition FROM ViewConditions WHERE ViewID=@viewId (@viewId=2)

                  Show Stacktrace

                  15 0.46 Web SQL Possible SELECT N+1.  This exact query is executed 8 times with different parameters.  Consider combining these queries into a single query.

                  SELECT Condition FROM ViewConditions WHERE ViewID=@viewId (@viewId=84)

                  Show Stacktrace

                  16 0.49 Web SQL Possible SELECT N+1.  This exact query is executed 8 times with different parameters.  Consider combining these queries into a single query.

                  SELECT Condition FROM ViewConditions WHERE ViewID=@viewId (@viewId=88)

                  Show Stacktrace

                  17 1.11 Web SQL Possible SELECT N+1.  This exact query is executed 8 times with different parameters.  Consider combining these queries into a single query.

                  SELECT Condition FROM ViewConditions WHERE ViewID=@viewId (@viewId=137)

                  Show Stacktrace

                  18 5.29 Web SWQL

                  SELECT NodeID FROM Orion.AssetInventory.Polling WHERE NodeID=@nodeID RETURN XML RAW (nodeID=1967)

                  Show Stacktrace

                  19 0.66 Web SQL Possible SELECT N+1.  This exact query is executed 8 times with different parameters.  Consider combining these queries into a single query.

                  SELECT Condition FROM ViewConditions WHERE ViewID=@viewId (@viewId=208)

                  Show Stacktrace

                  20 9.41 Web SWQL

                  SELECT TOP 1 pa.NodeID

                  FROM Orion.DPI.ProbeAssignments AS pa

                  INNER JOIN Orion.DPI.ApplicationAssignments AS aa ON pa.NodeID = pa.NodeID

                  WHERE pa.NodeID = @nodeId RETURN XML RAW (nodeId=1967)

                  Show Stacktrace

                  21 0.52 Web SQL Possible SELECT N+1.  This exact query is executed 8 times with different parameters.  Consider combining these queries into a single query.

                  SELECT Condition FROM ViewConditions WHERE ViewID=@viewId (@viewId=216)

                  Show Stacktrace

                  22 28.03 Web SWQL

                  SELECT Transactions.TransactionId

                                          FROM Orion.SEUM.Transactions

                                              JOIN Orion.Dependencies ON Transactions.Uri = Dependencies.ChildUri OR Transactions.Steps.Uri = Dependencies.ChildUri

                                              JOIN Orion.Nodes ON Dependencies.ParentUri = Nodes.Uri

                                          WHERE Nodes.NodeID = 1967 RETURN XML RAW

                  Show Stacktrace

                  23 0.62 Web SQL Possible SELECT N+1.  This exact query is executed 8 times with different parameters.  Consider combining these queries into a single query.

                  SELECT Condition FROM ViewConditions WHERE ViewID=@viewId (@viewId=133)

                  Show Stacktrace

                  24 5.89 Web SWQL

                  SELECT PollingSource FROM Orion.VIM.Hosts WHERE NodeID = @id UNION (SELECT PollingSource FROM Orion.VIM.VCenters WHERE NodeID = @id) UNION (SELECT PollingSource FROM Orion.VIM.VirtualMachines a WHERE NodeID = @id) RETURN XML RAW (id=1967)

                  Show Stacktrace

                  25 0.42 Web SQL Possible SELECT N+1.  This exact query is executed 8 times with different parameters.  Consider combining these queries into a single query.

                  SELECT Condition FROM ViewConditions WHERE ViewID=@viewId (@viewId=215)

                  Show Stacktrace

                  26 0.45 Web SQL

                  SELECT Count(*) FROM Views WHERE ViewGroup=@ViewGroup (@ViewGroup=1)

                  Show Stacktrace

                  27 0.94 Web SQL

                  SELECT ResourceProperties.* FROM ResourceProperties

                  INNER JOIN Resources ON ResourceProperties.ResourceID = Resources.ResourceID

                  WHERE Resources.ViewID=@view (@view=2)

                  Show Stacktrace

                  28 0.41 Web SQL

                  SELECT TOP 1 * FROM Views WHERE ViewID=@ViewID (@ViewID=2)

                  Show Stacktrace

                  29 0.85 Web SQL

                  SELECT * FROM Resources WHERE ViewID=@ViewID ORDER BY ViewColumn, Position  (@ViewID=2)

                  Show Stacktrace

                  30 4.99 Web SWQL

                  SELECT

                    hi.NodeID,

                    hi.PollingMethod,

                    hi.Manufacturer,

                    hi.Model,

                    hi.ServiceTag,

                    hi.LastPollStatus,

                    hi.LastPollMessage,

                    hi.LastPollTime,

                    hi.IsDisabled,

                    hi.AgentVersion,

                    hi.AgentUrl,

                    hi.AgentName,

                    n.IpAddress,

                    n.IPAddressType,

                    (SELECT COUNT(ID) AS InnerItemCount

                       FROM Orion.HardwareHealth.HardwareItem hwItem

                       WHERE hwItem.NodeID = hi.NodeID AND hwItem.IsDeleted = 0 AND hwItem.IsDisabled = 0

                     ) AS ItemCount

                  FROM

                    Orion.HardwareHealth.HardwareInfo hi, Orion.Nodes n

                  WHERE

                    hi.NodeID = @NodeID AND IsDisabled = 0 AND hi.NodeId = n.NodeId

                  RETURN XML RAW (NodeID=1967)

                  Show Stacktrace

                  31 0.50 Web SQL Possible SELECT N+1.  This exact query is executed 12 times with different parameters.  Consider combining these queries into a single query.

                  dbo.swsp_NetFlowGlobalSettingsGetSettings (@KeyName=CoreChartsShowDebugInfo)

                  Show Stacktrace

                  32 0.45 Web SQL Possible SELECT N+1.  This exact query is executed 12 times with different parameters.  Consider combining these queries into a single query.

                  dbo.swsp_NetFlowGlobalSettingsGetSettings (@KeyName=DefaultDetailTimePeriod)

                  Show Stacktrace

                  33 0.41 Web SQL Duplicate Query.  This exact query is execute 5 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT NodeID, IP_Address, Caption, Vendor, Status FROM Nodes WHERE NodeID = @node (node=1967)

                  Show Stacktrace

                  34 0.82 Web SQL Duplicate Query.  This exact query is execute 5 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT NodeID, IP_Address, Caption, Vendor, Status FROM Nodes WHERE NodeID = @node (node=1967)

                  Show Stacktrace

                  35 13.50 Web SWQL Duplicate Query.  This exact query is execute 3 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT TOP 1 ns.InterfaceID FROM Orion.NetFlow.Source ns

                  JOIN Orion.NPM.Interfaces i ON ns.InterfaceID = i.InterfaceID WHERE NodeID=1967 AND Enabled=1 RETURN XML RAW

                  Show Stacktrace

                  36 0.51 Web SQL Possible SELECT N+1.  This exact query is executed 12 times with different parameters.  Consider combining these queries into a single query.

                  dbo.swsp_NetFlowGlobalSettingsGetSettings (@KeyName=ChartGlobalDataUnits)

                  Show Stacktrace

                  37 0.39 Web SQL Possible SELECT N+1.  This exact query is executed 12 times with different parameters.  Consider combining these queries into a single query.

                  dbo.swsp_NetFlowGlobalSettingsGetSettings (@KeyName=ChartStyleOnDetailView)

                  Show Stacktrace

                  38 0.46 Web SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  dbo.swsp_NetFlowGlobalSettingsGetSettings (@KeyName=UseIfUtilization)

                  Show Stacktrace

                  39 0.47 Web SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=NTA_AreaChart)

                  Show Stacktrace

                  40 0.39 Web SQL Duplicate Query.  This exact query is execute 5 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT NodeID, IP_Address, Caption, Vendor, Status FROM Nodes WHERE NodeID = @node (node=1967)

                  Show Stacktrace

                  41 5.92 Web SWQL Duplicate Query.  This exact query is execute 3 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT TOP 1 ns.InterfaceID FROM Orion.NetFlow.Source ns

                  JOIN Orion.NPM.Interfaces i ON ns.InterfaceID = i.InterfaceID WHERE NodeID=1967 AND Enabled=1 RETURN XML RAW

                  Show Stacktrace

                  42 0.46 Web SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  dbo.swsp_NetFlowGlobalSettingsGetSettings (@KeyName=UseIfUtilization)

                  Show Stacktrace

                  43 0.41 Web SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=NTA_AreaChart)

                  Show Stacktrace

                  44 5.47 Web SWQL Possible SELECT N+1.  This exact query is executed 4 times with different parameters.  Consider combining these queries into a single query.

                  SELECT CustomPollerAssignmentID AS cnt FROM Orion.NPM.CustomPollerAssignment WHERE CustomPollerID=@guid AND NodeID=@nodeid RETURN XML RAW (guid=5c1f0283-04f1-41e9-a7a4-0d6e2909beba, nodeid=1967)

                  Show Stacktrace

                  45 0.42 Web SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=CustomPollerChart_Node)

                  Show Stacktrace

                  46 4.34 Web SWQL Duplicate Query.  This exact query is execute 8 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT Distinct RowID FROM Orion.NPM.CustomPollerStatus WHERE CustomPollerAssignmentID=@aid RETURN XML RAW (aid=00000000-0000-0000-0000-000000000000)

                  Show Stacktrace

                  47 4.27 Web SWQL Possible SELECT N+1.  This exact query is executed 4 times with different parameters.  Consider combining these queries into a single query.

                  SELECT CustomPollerAssignmentID AS cnt FROM Orion.NPM.CustomPollerAssignment WHERE CustomPollerID=@guid AND NodeID=@nodeid RETURN XML RAW (guid=7b634d16-42ff-44fb-82db-ecd277ef9da1, nodeid=1967)

                  Show Stacktrace

                  48 0.50 Web SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=CustomPollerChart_Node)

                  Show Stacktrace

                  49 4.43 Web SWQL Duplicate Query.  This exact query is execute 8 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT Distinct RowID FROM Orion.NPM.CustomPollerStatus WHERE CustomPollerAssignmentID=@aid RETURN XML RAW (aid=00000000-0000-0000-0000-000000000000)

                  Show Stacktrace

                  50 4.75 Web SWQL Possible SELECT N+1.  This exact query is executed 4 times with different parameters.  Consider combining these queries into a single query.

                  SELECT CustomPollerAssignmentID AS cnt FROM Orion.NPM.CustomPollerAssignment WHERE CustomPollerID=@guid AND NodeID=@nodeid RETURN XML RAW (guid=4f03e6fd-b277-4fa3-9dc6-0366dfc61bd3, nodeid=1967)

                  Show Stacktrace

                  51 0.38 Web SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=CustomPollerChart_Node)

                  Show Stacktrace

                  52 5.33 Web SWQL Duplicate Query.  This exact query is execute 8 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT Distinct RowID FROM Orion.NPM.CustomPollerStatus WHERE CustomPollerAssignmentID=@aid RETURN XML RAW (aid=00000000-0000-0000-0000-000000000000)

                  Show Stacktrace

                  53 4.51 Web SWQL Possible SELECT N+1.  This exact query is executed 4 times with different parameters.  Consider combining these queries into a single query.

                  SELECT CustomPollerAssignmentID AS cnt FROM Orion.NPM.CustomPollerAssignment WHERE CustomPollerID=@guid AND NodeID=@nodeid RETURN XML RAW (guid=22e5f7c3-eef4-4558-894d-758e2d3067a7, nodeid=1967)

                  Show Stacktrace

                  54 0.44 Web SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=CustomPollerChart_Node)

                  Show Stacktrace

                  55 4.30 Web SWQL Duplicate Query.  This exact query is execute 8 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT Distinct RowID FROM Orion.NPM.CustomPollerStatus WHERE CustomPollerAssignmentID=@aid RETURN XML RAW (aid=00000000-0000-0000-0000-000000000000)

                  Show Stacktrace

                  56 0.48 Web SQL Duplicate Query.  This exact query is execute 3 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=MultiUnDP)

                  Show Stacktrace

                  57 4.37 Web SWQL

                  SELECT CustomPollerAssignmentID FROM Orion.NPM.CustomPollerAssignment a WHERE @NetObjectID = NodeID AND InterfaceID = 0 AND a.CustomPollerID IN ('514bf492-f8ac-4674-b88a-45c0cb31e2bb','07ccc0f5-6113-4f95-8e58-b29560d09450','e107d11b-2620-4e08-b58a-d32e3f3d6d34','08a08cd2-2bc0-47fc-995e-44fd3b4dda2d') RETURN XML RAW (NetObjectID=1967)

                  Show Stacktrace

                  58 0.39 Web SQL Duplicate Query.  This exact query is execute 3 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=MultiUnDP)

                  Show Stacktrace

                  59 4.47 Web SWQL

                  SELECT CustomPollerAssignmentID FROM Orion.NPM.CustomPollerAssignment a WHERE @NetObjectID = NodeID AND InterfaceID = 0 AND a.CustomPollerID IN ('32649067-e77d-4a8c-9fe8-00b6955c4882') RETURN XML RAW (NetObjectID=1967)

                  Show Stacktrace

                  60 0.35 Web SQL Duplicate Query.  This exact query is execute 3 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=MultiUnDP)

                  Show Stacktrace

                  61 4.29 Web SWQL

                  SELECT CustomPollerAssignmentID FROM Orion.NPM.CustomPollerAssignment a WHERE @NetObjectID = NodeID AND InterfaceID = 0 AND a.CustomPollerID IN ('498338fa-f15b-43d9-b392-32cadcc826eb','bcae2b22-289a-4170-857f-834890d17d9d') RETURN XML RAW (NetObjectID=1967)

                  Show Stacktrace

                  62 1.01 Web SQL Duplicate Query.  This exact query is execute 5 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT NodeID, IP_Address, Caption, Vendor, Status FROM Nodes WHERE NodeID = @node (node=1967)

                  Show Stacktrace

                  63 5.57 Web SWQL Duplicate Query.  This exact query is execute 3 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT Hostname FROM Orion.NetFlow.CorrelationPostDNS WHERE IPAddressSort=@IPSort RETURN XML RAW (IPSort=10000008193)

                  Show Stacktrace

                  64 5.85 Web SWQL Duplicate Query.  This exact query is execute 3 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT Hostname FROM Orion.NetFlow.CorrelationPostDNS WHERE IPAddressSort=@IPSort RETURN XML RAW (IPSort=10000008193)

                  Show Stacktrace

                  65 0.43 Web SQL Possible SELECT N+1.  This exact query is executed 12 times with different parameters.  Consider combining these queries into a single query.

                  dbo.swsp_NetFlowGlobalSettingsGetSettings (@KeyName=DefaultSummaryFlowDirection)

                  Show Stacktrace

                  66 7.10 Web SWQL Duplicate Query.  This exact query is execute 3 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT Hostname FROM Orion.NetFlow.CorrelationPostDNS WHERE IPAddressSort=@IPSort RETURN XML RAW (IPSort=10000008193)

                  Show Stacktrace

                  67 0.39 Web SQL Possible SELECT N+1.  This exact query is executed 12 times with different parameters.  Consider combining these queries into a single query.

                  dbo.swsp_NetFlowGlobalSettingsGetSettings (@KeyName=DefaultSummaryTimePeriod)

                  Show Stacktrace

                  68 0.35 Web SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  dbo.swsp_NetFlowGlobalSettingsGetSettings (@KeyName=UseIfUtilization)

                  Show Stacktrace

                  69 1.85 Web SQL Possible SELECT N+1.  This exact query is executed 2 times with different parameters.  Consider combining these queries into a single query.

                  IF EXISTS(SELECT TOP 1 * FROM ResourceProperties WHERE ResourceID=@ResourceID AND PropertyName LIKE @PropertyName)

                                                          Update ResourceProperties SET PropertyValue=@PropertyValue WHERE ResourceID=@ResourceID AND PropertyName LIKE @PropertyName

                                                          ELSE

                                                          INSERT INTO ResourceProperties (ResourceID, PropertyName, PropertyValue) VALUES (@ResourceID, @PropertyName, @PropertyValue) (@ResourceID=2411, @PropertyName=ChartName, @PropertyValue=NTA_AreaChart)

                  Show Stacktrace

                  70 0.40 Web SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=NTA_AreaChart)

                  Show Stacktrace

                  71 0.44 Web SQL Duplicate Query.  This exact query is execute 5 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT NodeID, IP_Address, Caption, Vendor, Status FROM Nodes WHERE NodeID = @node (node=1967)

                  Show Stacktrace

                  72 6.13 Web SWQL Duplicate Query.  This exact query is execute 3 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT TOP 1 ns.InterfaceID FROM Orion.NetFlow.Source ns

                  JOIN Orion.NPM.Interfaces i ON ns.InterfaceID = i.InterfaceID WHERE NodeID=1967 AND Enabled=1 RETURN XML RAW

                  Show Stacktrace

                  73 0.40 Web SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  dbo.swsp_NetFlowGlobalSettingsGetSettings (@KeyName=UseIfUtilization)

                  Show Stacktrace

                  74 0.78 Web SQL Possible SELECT N+1.  This exact query is executed 2 times with different parameters.  Consider combining these queries into a single query.

                  IF EXISTS(SELECT TOP 1 * FROM ResourceProperties WHERE ResourceID=@ResourceID AND PropertyName LIKE @PropertyName)

                                                          Update ResourceProperties SET PropertyValue=@PropertyValue WHERE ResourceID=@ResourceID AND PropertyName LIKE @PropertyName

                                                          ELSE

                                                          INSERT INTO ResourceProperties (ResourceID, PropertyName, PropertyValue) VALUES (@ResourceID, @PropertyName, @PropertyValue) (@ResourceID=2438, @PropertyName=ChartName, @PropertyValue=NTA_AreaChart)

                  Show Stacktrace

                  75 0.44 Web SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=NTA_AreaChart)

                  Show Stacktrace

                  76 9.21 Web SWQL

                  -- appstack; Participation/Init

                  SELECT Stack, Category, EntityType, CategoryDisplayToken, UiOrder,

                  SystemUuid, RequiresInstall, MembershipJoins, MembershipInclude, MembershipExclude, UserOverride

                  FROM Orion.Stacks.Participation RETURN XML RAW

                  Show Stacktrace

                  77 11.56 Web SWQL

                  -- appstack; Participation/Init

                  SELECT X.EntityType, ME.BaseType, X.IsInjected FROM (

                    SELECT SourceType As EntityType, IsInjected FROM Metadata.Relationship WHERE BaseType = 'System.Reliance'

                      UNION ( SELECT TargetType As EntityType, 0 As IsInjected FROM Metadata.Relationship WHERE BaseType = 'System.Reliance' )

                    ) X

                    JOIN Metadata.Entity ME ON X.EntityType = ME.FullName RETURN XML RAW

                  Show Stacktrace

                  78 27.48 Web SWQL

                  -- appstack; Participation/Init

                  SELECT DISTINCT EntityName, PropertyName FROM Metadata.PropertyMetadata

                  WHERE Name = 'netObjectKeyIndex'

                  GROUP BY EntityName, PropertyName HAVING MIN(Value) = 0 WITH NOLOCK RETURN XML RAW

                  Show Stacktrace

                  79 26.79 Web SWQL

                  -- appstack; Participation/Init

                  SELECT SourceType, TargetType, SourcePropertyName, TargetPropertyName,

                  SourceCardinalityMin, SourceCardinalityMax, TargetCardinalityMin, TargetCardinalityMax

                  FROM Metadata.Relationship

                  WHERE SourceType IN ('Orion.APM.Application','Orion.Volumes','Orion.SEUM.Transactions','Orion.VIM.DataCenters','Orion.VIM.Clusters','Orion.VIM.Hosts','Orion.VIM.VirtualMachines','Orion.VIM.VCenters','Orion.Nodes','Orion.SEUM.TransactionSteps','Orion.VIM.Datastores','Orion.Groups') AND TargetType IN ('Orion.APM.Application','Orion.Volumes','Orion.SEUM.Transactions','Orion.VIM.DataCenters','Orion.VIM.Clusters','Orion.VIM.Hosts','Orion.VIM.VirtualMachines','Orion.VIM.VCenters','Orion.Nodes','Orion.SEUM.TransactionSteps','Orion.VIM.Datastores','Orion.Groups') AND BaseType = 'System.Hosting' RETURN XML RAW

                  Show Stacktrace

                  80 63.21 Web SWQL

                  -- appstack; Participation/Init

                  SELECT R.SourceType, R.TargetType, R.SourcePrimaryKeyNames, R.SourceForeignKeyNames

                  FROM Metadata.Relationship R

                  JOIN Metadata.RelationshipMetadata MR ON R.Name = MR.RelationshipName AND MR.Name = 'endsIdentical'

                  WHERE R.BaseType = 'System.Reliance' AND MR.Value = 'true' AND R.SourceType in @supported RETURN XML RAW (supported=System.String[])

                  Show Stacktrace

                  81 11.49 Web SWQL

                  -- appstack; AppstackFiltering/Init

                  SELECT ISNULL(AlwaysAdded,0) as AlwaysAdded, UiOrder, FilterPropertyJson FROM Orion.Stacks.FilterProperty WHERE Stack = 'app' RETURN XML RAW

                  Show Stacktrace

                  82 0.71 Web SQL Possible SELECT N+1.  This exact query is executed 19 times with different parameters.  Consider combining these queries into a single query.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=AvgRT)

                  Show Stacktrace

                  83 0.69 Web SQL Possible SELECT N+1.  This exact query is executed 19 times with different parameters.  Consider combining these queries into a single query.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=CiscoMMAvgCPULoad)

                  Show Stacktrace

                  84 185.17 Web SWQL Duplicate Query.  This exact query is execute 5 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT InstanceID

                  FROM Orion.TechnologyPollingAssignments AS data

                  WHERE data.TechnologyPolling.TechnologyID = @technologyId AND Enabled = 1 AND InstanceID IN (1967) RETURN XML RAW (technologyId=Node.CpuAndMemory)

                  Show Stacktrace

                  85 0.71 Web SQL Possible SELECT N+1.  This exact query is executed 19 times with different parameters.  Consider combining these queries into a single query.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=AvgCPUMultiLoad)

                  Show Stacktrace

                  86 140.80 Web SWQL Duplicate Query.  This exact query is execute 5 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT InstanceID

                  FROM Orion.TechnologyPollingAssignments AS data

                  WHERE data.TechnologyPolling.TechnologyID = @technologyId AND Enabled = 1 AND InstanceID IN (1967) RETURN XML RAW (technologyId=Node.CpuAndMemory)

                  Show Stacktrace

                  87 94.85 CoreBL SQL Possible SELECT N+1.  This exact query is executed 2 times with different parameters.  Consider combining these queries into a single query.

                  declare @@cpuCount int

                   

                   

                  Select @@cpuCount = count(Distinct CPUIndex)  FROM CPUMultiLoad

                  WHERE NodeID = @NodeId

                   

                   

                  if @@cpuCount <= 1

                  Select top 0 CPUIndex AS CPUName, CPUIndex, AvgLoad, TimeStampUTC from CPUMultiLoad

                  else

                  Select * from

                  (

                  Select ROW_NUMBER() OVER (order by z.AvgLoad DESC) as rnbr, * from

                  (

                  SELECT N'CPU # ' + CAST(CPUIndex + 1 as varchar(6)) as CPUName, CPUIndex, AvgLoad, TimeStampUTC,

                  DENSE_RANK() OVER (PARTITION BY CPUIndex ORDER BY TimeStampUTC desc) AS Rank

                  FROM CPUMultiLoad

                  WHERE NodeID = @NodeId) as z

                  where z.Rank = 1

                  ) t1 where t1.rnbr >((@PageNumber-1)*@PageSize) and t1.rnbr <=((@PageNumber)*@PageSize)

                  ORDER BY AvgLoad DESC

                  (@NodeId=1967, @PageNumber=1, @PageSize=0)

                  Show Stacktrace

                  88 6.75 Web BL Duplicate Query.  This exact query is execute 2 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  CoreBusinessLayer/GetNodeCPUsByPercentLoad

                  Show Stacktrace

                  89 0.78 Web SQL Possible SELECT N+1.  This exact query is executed 19 times with different parameters.  Consider combining these queries into a single query.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=CpuForecast)

                  Show Stacktrace

                  90 180.87 Web SWQL Duplicate Query.  This exact query is execute 5 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT InstanceID

                  FROM Orion.TechnologyPollingAssignments AS data

                  WHERE data.TechnologyPolling.TechnologyID = @technologyId AND Enabled = 1 AND InstanceID IN (1967) RETURN XML RAW (technologyId=Node.CpuAndMemory)

                  Show Stacktrace

                  91 0.67 Web SQL Possible SELECT N+1.  This exact query is executed 19 times with different parameters.  Consider combining these queries into a single query.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=MemoryForecast)

                  Show Stacktrace

                  92 172.17 Web SWQL Duplicate Query.  This exact query is execute 5 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT InstanceID

                  FROM Orion.TechnologyPollingAssignments AS data

                  WHERE data.TechnologyPolling.TechnologyID = @technologyId AND Enabled = 1 AND InstanceID IN (1967) RETURN XML RAW (technologyId=Node.CpuAndMemory)

                  Show Stacktrace

                  93 0.66 Web SQL Possible SELECT N+1.  This exact query is executed 19 times with different parameters.  Consider combining these queries into a single query.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=DeviceEnergyUsage)

                  Show Stacktrace

                  94 8.78 Web SWQL

                  SELECT COUNT(ID) AS cnt FROM Orion.NPM.EW.Device WHERE NodeID=@nodeid AND ISNULL(isEwEnabled, 0) = 1 RETURN XML RAW (nodeid=1967)

                  Show Stacktrace

                  95 191.05 Web SWQL Duplicate Query.  This exact query is execute 5 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT InstanceID

                  FROM Orion.TechnologyPollingAssignments AS data

                  WHERE data.TechnologyPolling.TechnologyID = @technologyId AND Enabled = 1 AND InstanceID IN (1967) RETURN XML RAW (technologyId=Node.CpuAndMemory)

                  Show Stacktrace

                  96 64.16 Web SWQL

                  SELECT count(NodeID) as cnt FROM Orion.Volumes where NodeID = @nodeId RETURN XML RAW (nodeId=1967)

                  Show Stacktrace

                  97 84.87 Web SWQL

                                                          Select N1Caption, I1ID, N2Caption ,I2ID FROM

                  (

                  SELECT Distinct

                    N1.NodeID as N1ID, N1.Caption as N1Caption, I1.InterfaceID as I1ID, N2.NodeID as N2ID, N2.Caption as N2Caption, I2.InterfaceID as I2ID, I2.InterfaceName as I2Name, I1.InterfaceName as I1Name

                    FROM Orion.TopologyConnections (nolock=true) as TopologyData

                                  Inner join Orion.Nodes (nolock=true) as N1 on TopologyData.SrcNodeID=N1.NodeID AND TopologyData.SrcType <> 'Orion.ShadowNodes' AND TopologyData.DestType <> 'Orion.ShadowNodes'

                                  Inner join Orion.Nodes (nolock=true) as N2 on TopologyData.DestNodeID=N2.NodeID AND TopologyData.SrcType <> 'Orion.ShadowNodes' AND TopologyData.DestType <> 'Orion.ShadowNodes'

                                  Left join Orion.NPM.Interfaces (nolock=true) as I1 on TopologyData.SrcInterfaceID=I1.InterfaceID

                                  Left join Orion.NPM.Interfaces (nolock=true) as I2 on TopologyData.DestInterfaceID=I2.InterfaceID

                                  LEFT OUTER JOIN Orion.NodesWebCommunityStrings (nolock=true) C1 ON C1.NodeID=N1.NodeID

                                  LEFT OUTER JOIN Orion.NodesWebCommunityStrings (nolock=true) C2 ON C2.NodeID=N2.NodeID

                  where N1.NodeID=1967

                   

                  Union

                  (

                  SELECT N1.NodeID as N1ID, N1.Caption as N1Caption, I1.InterfaceID as I1ID, N2.NodeID as N2ID, N2.Caption as N2Caption, I2.InterfaceID as I2ID, I2.InterfaceName as I2Name, I1.InterfaceName as I1Name

                  FROM Orion.TopologyConnections (nolock=true) as TopologyData

                                  Inner join Orion.Nodes (nolock=true) as N1 on TopologyData.DestNodeID=N1.NodeID AND TopologyData.SrcType <> 'Orion.ShadowNodes' AND TopologyData.DestType <> 'Orion.ShadowNodes'

                                  Inner join Orion.Nodes (nolock=true) as N2 on TopologyData.SrcNodeID=N2.NodeID AND TopologyData.SrcType <> 'Orion.ShadowNodes' AND TopologyData.DestType <> 'Orion.ShadowNodes'

                                  Left join Orion.NPM.Interfaces (nolock=true) as I1 on TopologyData.DestInterfaceID=I1.InterfaceID

                                  Left join Orion.NPM.Interfaces (nolock=true) as I2 on TopologyData.SrcInterfaceID=I2.InterfaceID

                                  LEFT OUTER JOIN Orion.NodesWebCommunityStrings (nolock=true) C1 ON C1.NodeID=N1.NodeID

                                  LEFT OUTER JOIN Orion.NodesWebCommunityStrings (nolock=true) C2 ON C2.NodeID=N2.NodeID

                  where N1.NodeID=1967

                  )

                   

                  ) t1  RETURN XML RAW

                  Show Stacktrace

                  98 167.60 Web SWQL

                                                          Select t1.ANodeID, t1.ACaption, t1.AGroupStatus,

                                  t1.AInterfaceID,

                                  ISNULL(t1.AInterfaceName, 'Unknown') AS AInterfaceName,

                                  ISNULL(t1.AOperStatusLED, 'Unknown.gif') AS AOperStatusLED,

                                  ISNULL(t1.AIntType, 0) AS AIntType,

                                  t1.BNodeID, t1.BCaption, t1.BGroupStatus,

                                  t1.BInterfaceID,

                                  ISNULL(t1.BInterfaceName, 'Unknown') AS BInterfaceName,

                                  ISNULL(t1.BOperStatusLED, 'Unknown.gif') AS BOperStatusLED,

                                  ISNULL(t1.BIntType, 0) as BIntType,

                                  t1.AGuid, t1.BGuid, t1.LayerType,

                                  t1.AIPAddress, t1.ADNS, t1.ASysName,

                                  t1.BIPAddress, t1.BDNS, t1.BSysName, t1.LinkSpeedFromDb

                                  FROM

                  (

                  SELECT Distinct

                                  N1.NodeID as ANodeID, N1.Caption as ACaption, N1.GroupStatus as AGroupStatus,

                                  I1.InterfaceID as AInterfaceID, I1.InterfaceName as AInterfaceName, I1.OperStatusLED as AOperStatusLED, I1.InterfaceType as AIntType,

                                  N2.NodeID as BNodeID, N2.Caption as BCaption, N2.GroupStatus as BGroupStatus,

                                  I2.InterfaceID as BInterfaceID, I2.InterfaceName as BInterfaceName, I2.OperStatusLED as BOperStatusLED, I2.InterfaceType as BIntType,

                                  C1.GUID as AGuid, C2.GUID as BGuid, LayerType,

                                  N1.IPAddress As AIPAddress, N1.DNS As ADNS, N1.SysName as ASysName,

                                  N2.IPAddress As BIPAddress, N2.DNS As BDNS, N2.SysName as BSysName,

                          CASE WHEN IsNull(I1.InterfaceSpeed, 0)  = 0  or IsNull(I2.InterfaceSpeed, 0) = 0 THEN -1

                               WHEN I1.InterfaceSpeed <= I2.InterfaceSpeed THEN (I1.InterfaceSpeed * 0.000001)

                               WHEN I2.InterfaceSpeed <= I1.InterfaceSpeed THEN (I2.InterfaceSpeed * 0.000001)

                          END as LinkSpeedFromDb

                    FROM Orion.TopologyConnections (nolock=true) as TopologyData

                                  Inner join Orion.Nodes (nolock=true) as N1 on TopologyData.SrcNodeID=N1.NodeID AND TopologyData.SrcType <> 'Orion.ShadowNodes' AND TopologyData.DestType <> 'Orion.ShadowNodes'

                                  Inner join Orion.Nodes (nolock=true) as N2 on TopologyData.DestNodeID=N2.NodeID AND TopologyData.SrcType <> 'Orion.ShadowNodes' AND TopologyData.DestType <> 'Orion.ShadowNodes'

                                  Left join Orion.NPM.Interfaces (nolock=true) as I1 on TopologyData.SrcInterfaceID=I1.InterfaceID

                                  Left join Orion.NPM.Interfaces (nolock=true) as I2 on TopologyData.DestInterfaceID=I2.InterfaceID

                                  LEFT OUTER JOIN Orion.NodesWebCommunityStrings (nolock=true) C1 ON C1.NodeID=N1.NodeID

                                  LEFT OUTER JOIN Orion.NodesWebCommunityStrings (nolock=true) C2 ON C2.NodeID=N2.NodeID

                  where N1.NodeID=1967

                   

                  Union

                  (

                  SELECT

                                  N1.NodeID as ANodeID, N1.Caption as ACaption, N1.GroupStatus as AGroupStatus,

                                  I1.InterfaceID as AInterfaceID, I1.InterfaceName as AInterfaceName, I1.OperStatusLED as AOperStatusLED, I1.InterfaceType as AIntType,

                                  N2.NodeID as BNodeID, N2.Caption as BCaption, N2.GroupStatus as BGroupStatus,

                                  I2.InterfaceID as BInterfaceID, I2.InterfaceName as BInterfaceName, I2.OperStatusLED as BOperStatusLED, I2.InterfaceType as BIntType,

                                  C1.GUID as AGuid, C2.GUID as BGuid, LayerType,

                                  N1.IPAddress As AIPAddress, N1.DNS As ADNS, N1.SysName as ASysName,

                                  N2.IPAddress As BIPAddress, N2.DNS As BDNS, N2.SysName as BSysName,

                          CASE WHEN IsNull(I1.InterfaceSpeed, 0)  = 0  or IsNull(I2.InterfaceSpeed, 0) = 0 THEN -1

                               WHEN I1.InterfaceSpeed <= I2.InterfaceSpeed THEN (I1.InterfaceSpeed * 0.000001)

                               WHEN I2.InterfaceSpeed <= I1.InterfaceSpeed THEN (I2.InterfaceSpeed * 0.000001)

                          END as LinkSpeedFromDb

                    FROM Orion.TopologyConnections (nolock=true) as TopologyData

                                  Inner join Orion.Nodes (nolock=true) as N1 on TopologyData.DestNodeID=N1.NodeID AND TopologyData.SrcType <> 'Orion.ShadowNodes' AND TopologyData.DestType <> 'Orion.ShadowNodes'

                                  Inner join Orion.Nodes (nolock=true) as N2 on TopologyData.SrcNodeID=N2.NodeID AND TopologyData.SrcType <> 'Orion.ShadowNodes' AND TopologyData.DestType <> 'Orion.ShadowNodes'

                                  Left join Orion.NPM.Interfaces (nolock=true) as I1 on TopologyData.DestInterfaceID=I1.InterfaceID

                                  Left join Orion.NPM.Interfaces (nolock=true) as I2 on TopologyData.SrcInterfaceID=I2.InterfaceID

                                  LEFT OUTER JOIN Orion.NodesWebCommunityStrings (nolock=true) C1 ON C1.NodeID=N1.NodeID

                                  LEFT OUTER JOIN Orion.NodesWebCommunityStrings (nolock=true) C2 ON C2.NodeID=N2.NodeID

                  where N1.NodeID=1967

                  )

                   

                  ) t1

                  Order by t1.ACaption, t1.AInterfaceName, t1.BCaption, t1.BInterfaceName RETURN XML RAW

                  Show Stacktrace

                  99 21.65 Web SWQL

                  SELECT COUNT(Application.ApplicationID) AS AppCount

                  FROM Orion.APM.Application  AS Application

                  JOIN Orion.Nodes n ON n.NodeId = Application.NodeID AND (Application.NodeID = 1967)

                  JOIN Orion.APM.ApplicationTemplate at ON at.ApplicationTemplateID = Application.ApplicationTemplateID

                                          JOIN Orion.APM.ApplicationCustomProperties AS APM_ApplicationCustomProperties

                                               ON APM_ApplicationCustomProperties.ApplicationID = Application.ApplicationID

                  RETURN XML RAW

                  Show Stacktrace

                  100 0.92 Web SQL Possible SELECT N+1.  This exact query is executed 19 times with different parameters.  Consider combining these queries into a single query.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=TotalDiskIOPS)

                  Show Stacktrace

                  101 28.00 Web SWQL

                  SELECT COUNT(*) AS CountOfAssignedPollers FROM Orion.Pollers

                          WHERE Enabled = 1 AND PollerType like '%V.Statistics%' AND NetObjectID IN

                  (SELECT VolumeID FROM Orion.Volumes WHERE NodeID = 1967)

                  RETURN XML RAW

                  Show Stacktrace

                  102 10.46 Web SWQL

                  Select ChildStatus From Orion.Nodes Where NodeID=1967 RETURN XML RAW

                  Show Stacktrace

                  103 6.20 Web BL

                  CoreBusinessLayer/GetInstalledModules

                  Show Stacktrace

                  104 21.97 Web SWQL

                  SELECT COUNT(VCenterID) as C

                                     FROM Orion.VIM.VCenters v INNER JOIN Orion.Nodes n ON v.NodeID=n.NodeID

                                    WHERE v.NodeID = 1967 RETURN XML RAW

                  Show Stacktrace

                  105 18.07 Web SWQL

                  SELECT COUNT(h.HostID) as C

                  FROM Orion.VIM.Hosts h

                  INNER JOIN Orion.Nodes n ON h.NodeID=n.NodeID

                  WHERE h.NodeID = 1967 RETURN XML RAW

                  Show Stacktrace

                  106 23.92 Web SWQL

                  SELECT COUNT(VirtualMachineID) as C

                                    FROM Orion.VIM.VirtualMachines vm

                                    INNER JOIN Orion.Nodes n ON vm.NodeID=n.NodeID

                                    WHERE vm.NodeID=1967 RETURN XML RAW

                  Show Stacktrace

                  107 21.61 Web SWQL

                  SELECT 

                  v.VCenterID,

                  v.NodeID,

                  v.Status,

                  v.DisplayName,

                  v.VMwareProductName,

                  v.VMwareProductVersion

                                     FROM Orion.VIM.VCenters v INNER JOIN Orion.Nodes n ON v.NodeID=n.NodeID

                                    WHERE v.NodeID = 1967 RETURN XML RAW

                  Show Stacktrace

                  108 25.02 Web SWQL

                  SELECT

                  h.HostID,

                  h.NodeID,

                  h.DataCenterID,

                  h.ClusterID,

                  h.Status,

                  h.DisplayName,

                  h.ManagedObjectID,

                  h.VmCount,

                  h.VmRunningCount,

                  h.NetworkUtilization,

                  h.ConnectionState,

                  h.Vendor,

                  h.VMwareProductName,

                  h.VMwareProductVersion,

                  h.Model,

                  h.PlatformID,

                  h.PollingSource,

                  h.DetailsUrl,

                  h.IPAddress

                  FROM Orion.VIM.Hosts h

                  INNER JOIN Orion.Nodes n ON h.NodeID=n.NodeID

                  WHERE h.NodeID = 1967 RETURN XML RAW

                  Show Stacktrace

                  109 7.44 Web SWQL

                  SELECT  vm.VirtualMachineID,

                  vm.NodeID,

                  vm.HostID,

                  vm.DisplayName,

                  vm.Status,

                  vm.GuestState,

                  vm.PowerState,

                  vm.IPAddress,

                  vm.PollingSource,

                  vm.PlatformID  FROM Orion.VIM.VirtualMachines vm INNER JOIN Orion.Nodes n ON vm.NodeID=n.NodeID WHERE vm.NodeID = 1967  RETURN XML RAW

                  Show Stacktrace

                  110 28.00 Web SWQL

                  SELECT

                  h.HostID,

                  h.NodeID,

                  h.DataCenterID,

                  h.ClusterID,

                  h.Status,

                  h.DisplayName,

                  h.ManagedObjectID,

                  h.VmCount,

                  h.VmRunningCount,

                  h.NetworkUtilization,

                  h.ConnectionState,

                  h.Vendor,

                  h.VMwareProductName,

                  h.VMwareProductVersion,

                  h.Model,

                  h.PlatformID,

                  h.PollingSource,

                  h.DetailsUrl,

                  h.IPAddress

                  FROM Orion.VIM.Hosts h

                  WHERE h.HostID = 44 RETURN XML RAW

                  Show Stacktrace

                  111 0.91 Web SQL Possible SELECT N+1.  This exact query is executed 2 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM Nodes WITH (NOLOCK) WHERE NodeID=@node (node=1681)

                  Show Stacktrace

                  112 31.91 Web SWQL

                  SELECT H.DetailsUrl AS DetailsUrl, H.DisplayName AS DisplayName, H.HostID as HostID

                  FROM Orion.VIM.VirtualMachines VM

                  LEFT JOIN Orion.VIM.Hosts H ON H.HostID = VM.HostID

                  WHERE VM.NodeID = 1967 RETURN XML RAW

                  Show Stacktrace

                  113 0.83 Web SQL

                  Select TOP 1 * FROM NodeSettings where NodeID = @NodeID AND SettingName =@SettingName ORDER BY SettingValue DESC (@NodeID=1967, @SettingName=Core.WebBrowseTemplate)

                  Show Stacktrace

                  114 1.02 Web SQL Possible SELECT N+1.  This exact query is executed 3 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM Settings WHERE RTRIM(SettingID) LIKE @SettingID (@SettingID=Web-ChartAspectRatio)

                  Show Stacktrace

                  115 18.37 Web SWQL

                  SELECT StartTime, EndTime, SampleMinutes, CanUseAggregated FROM Orion.NetFlow.TimePeriodCalculator(StartTime='2015-06-30T05:36:09', EndTime='2015-06-30T17:36:09', TrimStartTimeEndTime='True', ClientTimeZone='Eastern Standard Time') RETURN XML RAW

                  Show Stacktrace

                  116 0.74 Web SQL Possible SELECT N+1.  This exact query is executed 12 times with different parameters.  Consider combining these queries into a single query.

                  dbo.swsp_NetFlowGlobalSettingsGetSettings (@KeyName=EnableProgressiveCharting)

                  Show Stacktrace

                  117 0.68 Web SQL Possible SELECT N+1.  This exact query is executed 12 times with different parameters.  Consider combining these queries into a single query.

                  dbo.swsp_NetFlowGlobalSettingsGetSettings (@KeyName=DefaultNodeDetailFlowDirection)

                  Show Stacktrace

                  118 0.80 CoreBL SQL Possible SELECT N+1.  This exact query is executed 4 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM CustomPollers WHERE CustomPollerID=@CustomPollerId (@CustomPollerId=5c1f0283-04f1-41e9-a7a4-0d6e2909beba)

                  Show Stacktrace

                  119 0.64 CoreBL SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT * From TimeUnits WITH(NOLOCK)

                  Show Stacktrace

                  120 1.12 CoreBL SQL Possible SELECT N+1.  This exact query is executed 4 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM CustomPollerEnums WITH(NOLOCK) WHERE CustomPollerID=@poller (@poller=5c1f0283-04f1-41e9-a7a4-0d6e2909beba)

                  Show Stacktrace

                  121 19.35 Web BL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  NPMBusinessLayer/GetCustomPoller

                  Show Stacktrace

                  122 8.46 Web SWQL Duplicate Query.  This exact query is execute 8 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT Distinct RowID FROM Orion.NPM.CustomPollerStatus WHERE CustomPollerAssignmentID=@aid RETURN XML RAW (aid=00000000-0000-0000-0000-000000000000)

                  Show Stacktrace

                  123 0.69 CoreBL SQL Possible SELECT N+1.  This exact query is executed 4 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM CustomPollers WHERE CustomPollerID=@CustomPollerId (@CustomPollerId=7b634d16-42ff-44fb-82db-ecd277ef9da1)

                  Show Stacktrace

                  124 0.55 CoreBL SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT * From TimeUnits WITH(NOLOCK)

                  Show Stacktrace

                  125 0.58 CoreBL SQL Possible SELECT N+1.  This exact query is executed 4 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM CustomPollerEnums WITH(NOLOCK) WHERE CustomPollerID=@poller (@poller=7b634d16-42ff-44fb-82db-ecd277ef9da1)

                  Show Stacktrace

                  126 10.60 Web BL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  NPMBusinessLayer/GetCustomPoller

                  Show Stacktrace

                  127 7.75 Web SWQL Duplicate Query.  This exact query is execute 8 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT Distinct RowID FROM Orion.NPM.CustomPollerStatus WHERE CustomPollerAssignmentID=@aid RETURN XML RAW (aid=00000000-0000-0000-0000-000000000000)

                  Show Stacktrace

                  128 0.57 CoreBL SQL Possible SELECT N+1.  This exact query is executed 4 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM CustomPollers WHERE CustomPollerID=@CustomPollerId (@CustomPollerId=4f03e6fd-b277-4fa3-9dc6-0366dfc61bd3)

                  Show Stacktrace

                  129 0.45 CoreBL SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT * From TimeUnits WITH(NOLOCK)

                  Show Stacktrace

                  130 0.53 CoreBL SQL Possible SELECT N+1.  This exact query is executed 4 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM CustomPollerEnums WITH(NOLOCK) WHERE CustomPollerID=@poller (@poller=4f03e6fd-b277-4fa3-9dc6-0366dfc61bd3)

                  Show Stacktrace

                  131 10.36 Web BL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  NPMBusinessLayer/GetCustomPoller

                  Show Stacktrace

                  132 6.76 Web SWQL Duplicate Query.  This exact query is execute 8 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT Distinct RowID FROM Orion.NPM.CustomPollerStatus WHERE CustomPollerAssignmentID=@aid RETURN XML RAW (aid=00000000-0000-0000-0000-000000000000)

                  Show Stacktrace

                  133 0.55 CoreBL SQL Possible SELECT N+1.  This exact query is executed 4 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM CustomPollers WHERE CustomPollerID=@CustomPollerId (@CustomPollerId=22e5f7c3-eef4-4558-894d-758e2d3067a7)

                  Show Stacktrace

                  134 0.53 CoreBL SQL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT * From TimeUnits WITH(NOLOCK)

                  Show Stacktrace

                  135 0.42 CoreBL SQL Possible SELECT N+1.  This exact query is executed 4 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM CustomPollerEnums WITH(NOLOCK) WHERE CustomPollerID=@poller (@poller=22e5f7c3-eef4-4558-894d-758e2d3067a7)

                  Show Stacktrace

                  136 9.45 Web BL Duplicate Query.  This exact query is execute 4 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  NPMBusinessLayer/GetCustomPoller

                  Show Stacktrace

                  137 6.83 Web SWQL Duplicate Query.  This exact query is execute 8 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT Distinct RowID FROM Orion.NPM.CustomPollerStatus WHERE CustomPollerAssignmentID=@aid RETURN XML RAW (aid=00000000-0000-0000-0000-000000000000)

                  Show Stacktrace

                  138 7.36 Web SWQL

                  SELECT ApplicationID

                  FROM Orion.APM.Wstm.ScheduledTasksStatus

                  WHERE NodeID = @nodeId RETURN XML RAW (nodeId=1967)

                  Show Stacktrace

                  139 18.93 Web SWQL

                  SELECT COUNT(CPUIndex) AS cores

                          FROM Orion.CPUMultiLoad (nolock=true)

                  WHERE NodeID=@nodeId AND TimeStampUTC IN

                  (

                          SELECT TOP 1 TimeStampUTC

                                  FROM Orion.CPUMultiLoad

                          WHERE NodeID=@nodeId ORDER BY TimeStampUTC DESC

                  ) RETURN XML RAW (nodeId=1967)

                  Show Stacktrace

                  140 77.98 CoreBL SQL Possible SELECT N+1.  This exact query is executed 2 times with different parameters.  Consider combining these queries into a single query.

                  declare @@cpuCount int

                   

                   

                  Select @@cpuCount = count(Distinct CPUIndex)  FROM CPUMultiLoad

                  WHERE NodeID = @NodeId

                   

                   

                  if @@cpuCount <= 1

                  Select top 0 CPUIndex AS CPUName, CPUIndex, AvgLoad, TimeStampUTC from CPUMultiLoad

                  else

                  Select * from

                  (

                  Select ROW_NUMBER() OVER (order by z.AvgLoad DESC) as rnbr, * from

                  (

                  SELECT N'CPU # ' + CAST(CPUIndex + 1 as varchar(6)) as CPUName, CPUIndex, AvgLoad, TimeStampUTC,

                  DENSE_RANK() OVER (PARTITION BY CPUIndex ORDER BY TimeStampUTC desc) AS Rank

                  FROM CPUMultiLoad

                  WHERE NodeID = @NodeId) as z

                  where z.Rank = 1

                  ) t1 where t1.rnbr >((@PageNumber-1)*@PageSize) and t1.rnbr <=((@PageNumber)*@PageSize)

                  ORDER BY AvgLoad DESC

                  (@NodeId=1967, @PageNumber=1, @PageSize=20)

                  Show Stacktrace

                  141 7.42 Web BL Duplicate Query.  This exact query is execute 2 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  CoreBusinessLayer/GetNodeCPUsByPercentLoad

                  Show Stacktrace

                  142 1.03 Web SQL Possible SELECT N+1.  This exact query is executed 3 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM Settings WHERE RTRIM(SettingID) LIKE @SettingID (@SettingID=NetPerfMon-CPULoad-Error)

                  Show Stacktrace

                  143 0.82 Web SQL Possible SELECT N+1.  This exact query is executed 3 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM Settings WHERE RTRIM(SettingID) LIKE @SettingID (@SettingID=NetPerfMon-CPULoad-Warning)

                  Show Stacktrace

                  144 9.24 Web SWQL

                  SELECT Uri FROM Orion.Nodes WHERE NodeID = @nodeID RETURN XML RAW (nodeID=1967)

                  Show Stacktrace

                  145 0.67 Web SQL Possible SELECT N+1.  This exact query is executed 19 times with different parameters.  Consider combining these queries into a single query.

                  SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,

                                                          ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions,

                                                          IsExportEnabled, CustomPropertyKey, AnnotationLineColor, LoadingMode, ChartExportValueFormatter

                                                   FROM ChartSettings

                                                   WHERE ChartName = @ChartName (@ChartName=ApplicationHealthOverview)

                  Show Stacktrace

                  146 6.63 Web SWQL

                  SELECT VolumeID FROM Orion.Volumes WHERE NodeID = @NodeId RETURN XML RAW (NodeId=1967)

                  Show Stacktrace

                  147 0.50 Web SQL

                  SELECT ID FROM Modules WHERE ID=@TabID AND [Modules].[Disabled]='false' (@TabID=1)

                  Show Stacktrace

                  148 6.49 Web SWQL

                  SELECT c.ID FROM Orion.Wireless.Controllers AS c where (c.NodeID = @nodeId) RETURN XML RAW (nodeId=1967)

                  Show Stacktrace

                  149 0.00 Swis/Appstack BL

                  Swis/Appstack/Traverse -> Orion.Nodes:1967

                  Show Stacktrace

                  150 31.00 Swis/Appstack SWQL

                  -- appstack; GetMembershipInfractions

                  SELECT T0.NodeID FROM Orion.Nodes T0 WHERE (((T0.IsServer = 'true') OR (T0.NodeID IN (SELECT NodeId FROM Orion.VIM.VirtualMachines WHERE NodeID IS NOT NULL)) OR (T0.NodeID IN (Select NodeID FROM Orion.APM.Application WHERE NodeID IS NOT NULL))) AND  NOT ((T0.NodeID IN (SELECT NodeId FROM Orion.VIM.Hosts WHERE NodeID IS NOT NULL)) OR (T0.NodeID IN (SELECT NodeId FROM Orion.VIM.VCenters WHERE NodeID IS NOT NULL))))  AND (T0.NodeID IN (1967,1681)) WITH NOLOCK

                  Show Stacktrace

                  151 6.00 Swis/Appstack SWQL

                  -- appstack; GetMembershipInfractions

                  SELECT T0.VirtualMachineID FROM Orion.VIM.VirtualMachines T0 WHERE (((T0.NodeID IS NULL)))  AND (T0.VirtualMachineID IN (9069)) WITH NOLOCK

                  Show Stacktrace

                  152 12.00 Swis/Appstack SWQL

                  -- appstack; GetMembershipInfractions

                  SELECT T0.NodeID FROM Orion.Nodes T0 WHERE (((T0.NodeID IN (Select NodeID FROM Orion.VIM.Hosts WHERE NodeID IS NOT NULL))))  AND (T0.NodeID IN (1967,1681)) WITH NOLOCK

                  Show Stacktrace

                  153 5.00 Swis/Appstack SWQL

                  -- appstack; GetMembershipInfractions

                  SELECT T0.HostID FROM Orion.VIM.Hosts T0 WHERE (((T0.NodeID IS NULL)))  AND (T0.HostID IN (44)) WITH NOLOCK

                  Show Stacktrace

                  154 12.00 Swis/Appstack SWQL

                  -- appstack; GetMembershipInfractions

                  SELECT T0.NodeID FROM Orion.Nodes T0 WHERE (((T0.NodeID IN (Select NodeID FROM Orion.VIM.VCenters WHERE NodeID IS NOT NULL))))  AND (T0.NodeID IN (1967,1681)) WITH NOLOCK

                  Show Stacktrace

                  155 13.00 Swis/Appstack SWQL

                  -- appstack; GetMembershipInfractions

                  SELECT T0.VolumeID FROM Orion.Volumes T0 WHERE (((T0.VolumeTypeID IN (4,10,100))))  AND (T0.VolumeID IN (2908,2907,2906,2609,2610,2611,2612)) WITH NOLOCK

                  Show Stacktrace

                  156 32.00 Swis/Appstack SWQL

                  -- appstack; GetMissingDetails

                  SELECT X.EntityType, X.Id, X.Status, X.UiOrder, X.Severity, X.DisplayName, X.DetailsUrl, X.ChildStatus FROM (

                  SELECT 'Orion.Groups' as EntityType, A0.ContainerID as Id, A0.Status, S0.UiOrder, 0 As Severity, A0.DisplayName, A0.DetailsUrl, 1 As ChildStatus FROM Orion.Groups A0 JOIN Orion.StatusInfo S0 ON A0.Status = S0.StatusId WHERE A0.ContainerID IN (12,13)UNION (

                  SELECT 'Orion.Nodes' as EntityType, A1.NodeID as Id, A1.Status, S1.UiOrder, A1.UiSeverity As Severity, A1.DisplayName, A1.DetailsUrl, A1.ChildStatus As ChildStatus FROM Orion.Nodes A1 JOIN Orion.StatusInfo S1 ON A1.Status = S1.StatusId WHERE A1.NodeID IN (1967,1681) )

                  UNION (

                  SELECT 'Orion.Volumes' as EntityType, A2.VolumeID as Id, A2.Status, S2.UiOrder, 0 As Severity, A2.DisplayName, A2.DetailsUrl, 1 As ChildStatus FROM Orion.Volumes A2 JOIN Orion.StatusInfo S2 ON A2.Status = S2.StatusId WHERE A2.VolumeID IN (2908,2907,2610,2611,2612) )

                  ) X WITH NOLOCK []

                  Show Stacktrace

                  157 1.15 Web SQL

                  SELECT * FROM Modules INNER JOIN UserTabs ON Modules.ID = UserTabs.TabID 

                                                                                          WHERE AccountID = @AccountID  AND UserTabs.MenuBarID <> 'none'  AND [Modules].[Disabled]='false' ORDER BY TabPosition (@AccountID=DOMAIN\david.speer)

                  Show Stacktrace

                  158 1.03 Web SQL Possible SELECT N+1.  This exact query is executed 7 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID

                                                       WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=Admin)

                  Show Stacktrace

                  159 0.94 Web SQL

                  SELECT Credential.ID, Credential.Name, Credential.Description, CredentialProperty.Name AS PropertyName, CredentialProperty.Value AS PropertyValue, CredentialProperty.Encrypted AS PropertyEncrypted

                  FROM Credential

                    JOIN CredentialProperty ON Credential.ID = CredentialProperty.CredentialID

                  WHERE Credential.CredentialType = @CredentialType

                    AND Credential.CredentialOwner = @Owner

                    AND Credential.Name LIKE @NamePattern

                  ORDER BY Credential.Name, Credential.ID, CredentialProperty.Name (@CredentialType=SolarWinds.Orion.Core.SharedCredentials.Credentials.UsernamePasswordCredential, @Owner=DPA.Integration, @NamePattern=__DPA.Service.Account)

                  Show Stacktrace

                  160 2.27 Web BL Duplicate Query.  This exact query is execute 6 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  CoreBusinessLayer/IsModuleInstalledbyTabName

                  Show Stacktrace

                  161 0.81 Web SQL Possible SELECT N+1.  This exact query is executed 7 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID

                                                       WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=Network_TabMenu)

                  Show Stacktrace

                  162 1.81 Web BL Duplicate Query.  This exact query is execute 6 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  CoreBusinessLayer/IsModuleInstalledbyTabName

                  Show Stacktrace

                  163 1.01 Web SQL Possible SELECT N+1.  This exact query is executed 7 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID

                                                       WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=NTA_TabMenu)

                  Show Stacktrace

                  164 3.40 Web BL Duplicate Query.  This exact query is execute 6 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  CoreBusinessLayer/IsModuleInstalledbyTabName

                  Show Stacktrace

                  165 1.26 Web SQL Possible SELECT N+1.  This exact query is executed 7 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID

                                                       WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=APM_TabMenu)

                  Show Stacktrace

                  166 1.65 Web BL Duplicate Query.  This exact query is execute 6 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  CoreBusinessLayer/IsModuleInstalledbyTabName

                  Show Stacktrace

                  167 0.67 Web SQL Possible SELECT N+1.  This exact query is executed 7 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID

                                                       WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=Virtualization_TabMenu)

                  Show Stacktrace

                  168 1.53 Web BL Duplicate Query.  This exact query is execute 6 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  CoreBusinessLayer/IsModuleInstalledbyTabName

                  Show Stacktrace

                  169 0.53 Web SQL Possible SELECT N+1.  This exact query is executed 7 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID

                                                       WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=Transactions_TabMenu)

                  Show Stacktrace

                  170 1.58 Web BL Duplicate Query.  This exact query is execute 6 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  CoreBusinessLayer/IsModuleInstalledbyTabName

                  Show Stacktrace

                  171 0.74 Web SQL Possible SELECT N+1.  This exact query is executed 7 times with different parameters.  Consider combining these queries into a single query.

                  SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID

                                                       WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=Databases_TabMenu)

                  Show Stacktrace

                  172 4.06 Web BL

                  CoreBusinessLayer/GetNotificationItemTypes

                  Show Stacktrace

                  173 0.76 CoreBL SQL

                  SELECT NotificationTypeID, COUNT(NotificationID) as TheCount FROM NotificationItems WHERE AcknowledgedAt IS NULL AND Ignored=0 GROUP BY NotificationTypeID

                  Show Stacktrace

                  174 4.83 Web BL

                  CoreBusinessLayer/GetAvailableNotificationItemsCounts

                  Show Stacktrace

                  175 0.67 Web SQL Duplicate Query.  This exact query is execute 2 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT CurrentValue FROM Settings WHERE SettingID=@SettingID (@SettingID=ForecastMinDays)

                  Show Stacktrace

                  176 8.77 Web SWQL

                  SELECT TOP 1 NodeID FROM Orion.CPULoad WHERE NodeID = @nodeId AND DateTime < @minDateTime AND DateTime > @minDateTimeMinusDay RETURN XML RAW (nodeId=1967, minDateTime=6/23/2015 5:36:11 PM, minDateTimeMinusDay=6/22/2015 5:36:11 PM)

                  Show Stacktrace

                  177 0.58 Web SQL Duplicate Query.  This exact query is execute 2 times with the same parameters.  Consider caching the query's results so that the query is only executed once.

                  SELECT CurrentValue FROM Settings WHERE SettingID=@SettingID (@SettingID=ForecastMinDays)

                  Show Stacktrace

                  178 8.90 Web SWQL

                  SELECT TOP 1 NodeID FROM Orion.VolumeUsageHistory WHERE NodeID = @nodeId AND DateTime < @minDateTime AND DateTime > @minDateTimeMinusDay RETURN XML RAW (nodeId=1967, minDateTime=6/23/2015 5:36:11 PM, minDateTimeMinusDay=6/22/2015 5:36:11 PM)

                  Show Stacktrace

                • Re: What is the root cause of intermittent sluggishness, especially when viewing node details in the Web Interface?
                  david.speer

                  I've submitted a case for this on the support side.

                  We're seeing 45 - 90 second load times when looking at node details.

                  Most of the application views have great response times.

                   

                  Case #829670 - "Sluggish response in some views"