One Specific ACS Custom Report "loading forever with hug memory consumption" RRS feed

  • Question

  • Hi Folks,

    I uploaded a custom ACS Reports related to AD Groups .. 

    All of them are working except "Removed Members from Security Groups" .. loading forever and with time Memory consumption related to the SSRS Service is getting higher till server memory reach 99% memory utilization and never show results.

    My logs history is configured for only 7 days.. so there should be no hug data to take time also my DB size about 30GB only

    I uploaded this report to a lab SCOM Server and it's working !!! problem is there's no error msg ! only loading 

    So my guess it's a DB issue .. appreciate help where to look to determine the root cause of the issue

    Wednesday, June 1, 2016 12:30 PM