Orion Web Console Slowness

SELECT 1

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

SELECT SettingName, SettingValue FROM WebSettings

SELECT * FROM Accounts WHERE AccountID=@AccountID (@AccountID=admin)

SELECT SettingName, SettingValue FROM WebUserSettings WHERE AccountID=@account  (@account=admin)

SELECT PermissionName, PermissionValue FROM APM_WebUserPermissions WHERE AccountID = @account (@account=admin)

SELECT * FROM Views WHERE ViewGroup=@ViewGroup 
                                  Order by ViewGroupPosition (@ViewGroup=0)

SELECT ResourceProperties.* FROM ResourceProperties 
 INNER JOIN Resources ON ResourceProperties.ResourceID = Resources.ResourceID 
 WHERE Resources.ViewID=@view (@view=80)

SELECT * FROM Views WHERE ViewID=@ViewID (@ViewID=80)

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

SELECT ServerName, BusinessLayerPort FROM dbo.Engines WHERE ServerType = 'Primary' ORDER BY KeepAlive DESC

SELECT ElementType, MaxElementCount FROM Orion.ElementInfo RETURN XML RAW

SELECT FeatureName FROM Orion.EnabledFeatures RETURN XML RAW

SELECT Name, Version, IsEval, DaysRemaining, IsExpired, IsRC, IsScalable FROM Orion.InstalledModule RETURN XML RAW

SELECT hu.ID, hu.HtmlText 
 FROM Orion.HardwareHealth.HardwareUnit hu RETURN XML RAW

SELECT COUNT(hf.NodeID) AS ServersCount FROM Orion.APM.HardwareInfo AS hf  
 JOIN Orion.Nodes AS no ON hf.NodeID = no.NodeID        
 WHERE IsDisabled = 'false' RETURN XML RAW

SELECT ChartName, NetObjectPrefix, Owner, IsSystemChart, DisplayName, DataUrl,  
                                         ChartOptions, LegendUserControl, ChartRenderingEventHandler, HelpLinkFragment, ChartEditOptions, IsExportEnabled 
                                  FROM ChartSettings 
                                  WHERE ChartName = @ChartName (@ChartName=HardwareHealthOverview)

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

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

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=admin)

SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID 
                                      WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=Admin)

CoreBusinessLayer/IsModuleInstalledbyTabName

SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID 
                                      WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=Network_TabMenu)

CoreBusinessLayer/IsModuleInstalledbyTabName

SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID 
                                      WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=APM_TabMenu)

CoreBusinessLayer/IsModuleInstalledbyTabName

SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID 
                                      WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=IPSLAM_TabMenu)

CoreBusinessLayer/IsModuleInstalledbyTabName

SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID 
                                      WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=VNQM_TabMenu)

CoreBusinessLayer/IsModuleInstalledbyTabName

SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID 
                                      WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=Transactions_TabMenu)

CoreBusinessLayer/IsModuleInstalledbyTabName

SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID 
                                      WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=Storage_TabMenu)

CoreBusinessLayer/IsModuleInstalledbyTabName

SELECT * FROM MenuItems INNER JOIN MenuBars ON MenuItems.MenuItemID=MenuBars.MenuItemID 
                                      WHERE MenuBars.MenuName = @menuName ORDER BY Position (@menuName=Virtualization_TabMenu)

CoreBusinessLayer/IsModuleInstalledbyTabName

CoreBusinessLayer/GetNotificationItemTypes

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

CoreBusinessLayer/GetAvailableNotificationItemsCounts

Show
Stacktrace