Events/Traps Web Resources Load EXTREMELY slow

Question

The Events and Traps resources on the webpage that are loaded from the toolbar take on average 30 seconds to load no matter how many events/traps I set it to load...could be 5..could be 250...still takes 30 seconds.  All other events and traps web resources load quickly.  Last XX Traps on my node details page takes no time to load.  Event Summary on my home page takes no time to load.  If I click on one of the event types on event summary....takes 30 seconds to load.

Trap issue started when I upgraded to version 9 of NPM

Event issue started when I upgraded to version 9.5 of NPM

Case#99257 and 64389 (original trap issue ticket) have been raised.

I am willing to assist the dev team in figuring out what changed during the upgrades to make these two resources slower. So far I keep being told "the next service pack will fix it"...so far version releases and service packs have done nothing to address issue.

Has anyone else out there noticed this behavior?  Please post if you have so we can get some push going for this request.

FormerMember · Answer

i have the same isssue....  my traps and syslog page take ages to run on both the core webserver and the additional webserver

brian_duvall · Answer

I read that post as well.  It did have to do with indexing those tables manually.  Solarwinds support replied that they would include it and so far I haven't seen any performance increase.

Plus I was a little hesitant to do the db work since I feel the issue is more with those resources since the db calls from the other events/traps web resources reply back quickly.  It must be the way they try to retrieve the data from those two toolbar links.  I am sure syslog users may be having same issue.

ecornwell · Answer

I read in another post where someone had created something for the database and it helped resolve some slowness issues. ( I'm no database guy so I didn't really understand what they were talking about.  I think it was something about an index...)  I thought that someone from SW responded and it sounded like they were looking at adding it to a SP for everyone.  I think it delt with both syslog and traps.