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

This may be related to the following post.

• Allow precompilation of NPM pages

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.

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

I didn't see the SVCHost process spawning csc.exe. I do know that we skipped the optimization step during update. Our NPM admin was driving, and he commented that , this always takes too long and skipped it

I'll run the configuration wizard again as you mention below.

I've performed the 3 steps.

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 Multiproce​ssor Free)

  Location Default-Fi​rst-Site-N​ame

  Contact 

  SysObjectID 

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

  Software Version 6.2 (Build 9200 Multiproce​ssor 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

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"

Worked with support on this -

The issue was a previous vm integration demo that had expired and the host had been taken offline.

On the virtualization integration tab we removed the association with the old host and the issues sorted.