Hi! Since also the SP4 update did not help (like SP3 didn't) and the support hasn't been able to address this problem yet (case 115491), I though I could try to gather some experiences here.
The problem is that the Events page (also Traps, but let's concentrate on Events here) is taking something like 30-50 seconds to load.
The events themselves can be fetched from the database very fast, there is no database performance problem identified with this problem. This is easily verified by seeing that the "Last 250 events" report is loading very fast (two seconds or so), and also the NPM "Home" page is loading fast (it has Last XXX Events component showing, among other components). It is just the Events.aspx page that is loading slow.
If I for example choose to show only ten (10) events in the Events page, the loading time is some 40 seconds, it shows the ten last events, but the resulting html page is very large.
Let's see the html page a bit more:
- about 250 kB of it is the node dropdown list (we have some 4000 nodes)
- about 250 kB of it is the VIEWSTATE hidden input variable (which nobody seems to tell anything, I've asked this a couple of times from support)
Total of about 500 kB according to Internet Explorer. However, Firefox says over 3000 kB. I don't know where Firefox calculates that value, maybe it counts also the javascript files etc into that figure.
This problem started when upgraded from 9.1SP4 to 9.5. It is present at least with 9.5.0, 9.5SP2, 9.5SP3 and 9.5SP4 (two pollers and total of 14000 elements).
Do you have any idea what's going on?
This is very bad because the web interface is totally stuck for all users while the application is thinking the Events page request (you see, whole application stalls for 40 seconds). "SolarWinds.BusinessLayerHost.exe" process gets excited (starts using lots of CPU) when the Events page is loading.
Markku