Some initial steps and information to gather to assist with troubleshooting performance issues.
Please provide all relevant information to Support when opening a new service request.
See also: How to configure settings as per the System Information Overview
IMPT Note -: As OneIM does not come with a Performance Monitoring system. The Overview report provides best-practice good-known recommended specification require for 1IM to perform efficiently. It is crucial that customer meet all the recommended specification in the overview report as failure to do so may likely result in poor database perfromance.
3. Is there a long running query (or queries) in the SQL logs? What happens when this is run manually?
Create an actual execution plan for this query (see below).
Execution plans provide feedback for DBAs on why a query may be performing badly, how to improve this, i.e. indexes, defragmentation, etc. DBAs should review the actual execution plan and provide a copy to Support for review.
Note: Ensure this is the actual execution plan: Display an Actual Execution Plan.
4. Is the SQL server running on a virtual system?
Identity Manager Database Virtualization Recommendations
Synchronization Performance
Several factors can contribute to how long a synchronization with a target system takes to complete.
- Are there outstanding patches for the synchronization project? In the Synchronization Editor go to Edit | Update synchronization project... then apply any applicable patches.
- Is the latest service pack installed? Ensure the latest service pack has been applied so that the synchronization is not affected by any resolved issues. Check for existing patches as well for the applicable version: Identity Manager - Download Software.
- Support may request the synchronization project for further review: How to export the Synchronization Project shell from the Synchronization Editor
Database Performance:
Run the provided Serverinfo.sql (not 1IM version specific), to gather performance values from the SQL server. Customers may send Support the output, and they should also review themselves and compare with the min. requirements for the database, as per the release notes. For version 7.x and above please run Select * from qbmvsystemoverview.
Average Total Latency (ms) | Rating |
<1 ms | Excellent |
<5 ms | Very good |
<5 – 10 ms | Good |
< 10 – 20 ms | Poor |
< 20 – 100 ms | Bad |
<100 ms -500 ms | Very Bad |
> 500 ms | Awful |
Execution Plans
Note: Ensure this is the actual execution plan: Display an Actual Execution Plan.
System Requirements
SQL Server and Oracle Database servers should ALWAYS meet the minimum system requirements! Please refer to the system requirements for the specific version of One Identity Manager.
Identity Manager - Technical Documentation
Trace Flag
Enabling Trace flag 2453 may improve overall database performance. The Database Journal may report this, "Trace flag 2453 should be enabled." Steps to enable this are included in Knowledge Base Article 226333, What does "Trace flag 2453 should be enabled." mean?
© 2021 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy