• In V9.0 LTS profileHasAuthObjectField step, while synching SAP authorization details from Target System it is not synching the data when records are huge

    In V9.0 LTS profileHasAuthObjectField step, while synching SAP authorization details from Target System it is not synching the data when records are huge.

    This step at first instance was supposed to fetch around 80 millions of records which is not able…

  • Clustered index in One Identity?

    Hello everyone,

    I see in the official documentation that I can create new index using the schema extension tool. But I have two questions?

    1. Could this index create directly in the database?
    2. One Identity allow create new Clustered index?

    Thank you…

  • SoD Checks directly in Web Shop causes massive performance issues

    Currently we have more than 180 SoD Rules defined, which should be checked directly during the save process in the Web Shop to give the user direct feedback if the request could be send or not.

    In version 6 the overall performance for an end user as acceptable…

  • How to improve DB performance? Can we add index on DB?

    Hi,

    We have 55k users in One IM for which we are trying to provision AD accounts for these users. We have increased DB capacity to 16CPU/64GB and enabled the trace flag as well. And the staging level of DB is set to "Production". Still, the performance…

  • Problem with database performance

    Hello all,

     

    We are facing a problem with the database. We found out that when we are using the web portal, some pages are taking a lot of time to load. Digging into the problem, in the logs we can see a problem with a query related with the AccProduct…