Skip to Content

UI Causing High CPU Utilization

We're having a situation where the UI is hitting the database server and causing 100% utilization of the CPU on that machine. Every time we bring the IDM services down on our portal, the CPU usage drops to normal and when we start it back up, we're at 100% again.

Has anyone seen anything like this? What might cause the UI to hit the database so hard for hours?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 04, 2016 at 08:43 PM

    Hey Brandon, if you figured this out let us know what happened!

    Thanks,

    Matt

    Add comment
    10|10000 characters needed characters exceeded

    • We did get it figured out but I still don't have a clear answer. The best I can figure out is, there was a SQL query on the UI side that was being used by an end user in a way that IDM team hadn't anticipated. Thus, it was just endlessly returning information, thus maxing out the CPU. Once the query was altered to account for this By putting a cap on the number of rows it could return, the problem went away.

      That doesn't even sound like a perfect answer though. Once I get more information, I'll update.

  • May 04, 2016 at 09:38 AM

    Hello Brandon,

    sounds like a problem in the AS Java not the database. Have you checked the "Availability and Performance" in the NWA already? Maybe there's something in the logs. Or checking the database monitoring for a query which may be heavy load.

    I experienced something similar when people did a multiple * search on the person. Back then the search task had around 25 attributes. After cutting them down it got better.

    Best regards

    Dominik

    Add comment
    10|10000 characters needed characters exceeded