Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Orion Web Console Slowness

Hi All, I have NPM10.4 and SAM 5.0.2, while accessing both through Orion Web Conslo, I feel there is a slowness in getting the page, and its taking much time everytime im logging,

I have the SQL db installed on remote server which have 4GB RAM and 4CPUs also on ORION server I have 4GB and 4CPU running on VM, anyone have an idea about what is the issue?

Thanks,

Find more posts tagged with

Accepted answers

All comments

petrf

Hi,

is it a fresh installation on a fresh server? Are you the only user of Orion?

FormerMember

Hi thanks for reply, actually it was running on another server very slow, I
have just done the fresh installation on fresh server and pointed the modules
to the same DB, but still running very slow,

we are here 6 users accessing daily, also I'm managing around 550 server,
1000 volume and around 500 interface,

Thanks,

petrf

It can be caused by real-time anti-virus scanning enabled on the Orion server which can cause web site recompilation. Try to disable AV or exclude the inetpub directory.

Or it can be caused by certificate revocation list (CRL) checking. If Orion server doesn't have internet access Windows CRL mechanism is trying to reach Microsoft servers to download it and there is a quite long timeout which can cause slowness.

Try to solve it in your environment or disable it on Orion server or in domain policy.

Note that Microsoft doesn't recommend to disable it on production systems.

Related links:

1) http://support.microsoft.com/kb/936707 - this must be done also for .NET framework 4

2) http://technet.microsoft.com/en-us/library/cc753863.aspx - related to domain policy

mdriskell

Just curious but what is your memory utilization on both the SQL server and your SolarWinds server? I'd be very concerned about SQL 4GB will barely handle the OS let alone a DB.

netlogix

you can also find out if there is a specific part that is slow by looking at the hubble info.

to do that change value to "true" in c:\inetpub\solarwinds\web.config (or where your web-site is) for section <add key="HubbleActive" value="true"/>

FormerMember

Hi netlogix, Thanks for your reply, actually I have enabled the "HubbleActive" value then I started getting something like the below which I'm not able to analyze, can you help me in this:

Thanks in advance,

27155 ms. 29 queries. 10 BL calls. 2 Warnings. 9 KB ViewState. 11 Styles » Details

View Cached Hubble Results

Database Time:	4854 ms	17.9 %
Business Layer Time:	95 ms	0.3 %
Other Time:	22206 ms	81.8 %
Total Time:	27155 ms	100.0 %

View State Size:	9 KB
Stylesheet Count:	11

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.

SELECT 1
SELECT * FROM Views WHERE RTRIM(ViewType) LIKE ViewType ViewType=Summary)
SELECT SettingName, SettingValue FROM WebSettings
SELECT * FROM Accounts WHERE AccountIDAccountID AccountID=admin)
SELECT SettingName, SettingValue FROM WebUserSettings WHERE AccountIDaccount  account=admin)
SELECT PermissionName, PermissionValue FROM APM_WebUserPermissions WHERE AccountID = account account=admin)
SELECT * FROM Views WHERE ViewGroupViewGroup                                   Order by ViewGroupPosition ViewGroup=0)
SELECT ResourceProperties.* FROM ResourceProperties INNER JOIN Resources ON ResourceProperties.ResourceID = Resources.ResourceID WHERE Resources.ViewIDview view=80)
SELECT * FROM Views WHERE ViewIDViewID ViewID=80)
SELECT * FROM Resources WHERE ViewIDViewID 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 IDTabID 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

netlogix

Other Time: 22206 ms 81.8% - I would suspect either something in IIS or the OS itself.

netlogix

here is mine when I am looking at an interface.

Database Time:	1397 ms	91.9 %
Business Layer Time:	31 ms	2.1 %
Other Time:	93 ms	6.1 %
Total Time:	1521 ms	100.0 %
View State Size:	26 KB

FormerMember

Its a fresh installation, OS and all ORION modules just reinstalled 5 hours ago trying to solve this issue and other issue as well, I have pointed the modules to the same DB, also I have updated the OS with the latest updates, so what could be the OS issue??

I have an active case with SolarWinds team, they have connected remotely today and tried to investigate more but no luck in finding the root cause,

All I think now is to restore a month back DB, there was no issue, but I afraid this issue will come again,

Any suggestion?

Thanks,

Rami

FormerMember

Compairing with yours, seem my server is wasting time in doing something other than getting data fromt he DB, seems like timeout issue or waiting for something:(

mdriskell

I'll go back to my original question...what is the memory utilization of your SW server. 4GB is awfully low for a server.

FormerMember

Hi Driskell,

I have 4GB dedicated just for the Application as no DB installed on the same server, I have the DB on remote server, the memory utilization is not exceeding the 3.5GB, always I have 1GB free in the Task Manager, is it ok or I have to add more memory, I'm running ORION on VM, easly I can add more memory right now if required?

Thanks,

FormerMember

Sorry just forgot, I have requested the Sys. admins to increase the memory last week, actually its running on 8GB,

Thanks,

netlogix

what OS are you running? 64 bit?

DB restore makes it go away!?!? hmm... that doesn't make any sense! Not a Web server, have you tried re-indexing? oh, also check the maintinance log \ProgramData\Solarwinds\Logs\Orion\swdebugMaintenance.log maybe the rollup is broken (just search for "error").

FormerMember

Its Windows 2008 Ent. R2 64bit,

The log file is not exist on the server under solarwinds, I have searched all the paths!

Thanks,

donpepe

When my server ran slow we were able to speed things up by doing two things. Making sure we had the latest and greatest version of all the modules (helped alot!) and we identified issues with the communication between the web front end and the database in the front ends event log. It showed plenty of time outs waiting for data to come back from the database. once we fixed both of those our server has been zipping along.

Sohail.Bhamani

Do you have a very large number of groups created? Do you have a very large amount of syslog and traps? I have seen in many customer environments where large amounts of those cause front end slow downs.

Do you have a maintenance plan on your sql db that reindex's the db? Is your SQL server physical or a vm? What kind of storage is being used for db, log, and temp db?

These are things sometimes less evident compared to RAM and CPU usage.

Sohail Bhamani

Loop1 Systems

http://www.loop1systems.com

PavelSrot

It can be also caused by, that if for longer time anyone don't access to website, IIS worker process will shutdown. You can eliminate this by increasing Idele Time-out for application pool via Internet Information Service Manager Concole (Advanced Settings... on selected application pool).