Rebuild Table Index

Hello,

We are user One Identity 8.2 version and then every morning rebuild table index running on DbQueue and Its not ending.Its working 4 5 hours. How to solve this problem? Because when rebuild table index running, other process it not working. Its waiting for it to end.

Parents

0 Trevor Pike over 1 year ago

Hi,

There have been other posts on this task that you should look into as well. For your version, there is more information here:

https://support.oneidentity.com/technical-documents/identity-manager/8.2/operational-guide/11#TOPIC-1721782

But basically, you have tables with large amounts of data and the task takes longer as a result. And potentially there are database performance issues.

Have your DBA take a look for any tables that are very large and/or missing indexes.

Trevor
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel

Reply

0 Trevor Pike over 1 year ago

Hi,

There have been other posts on this task that you should look into as well. For your version, there is more information here:

https://support.oneidentity.com/technical-documents/identity-manager/8.2/operational-guide/11#TOPIC-1721782

But basically, you have tables with large amounts of data and the task takes longer as a result. And potentially there are database performance issues.

Have your DBA take a look for any tables that are very large and/or missing indexes.

Trevor
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel

Children

No Data