-
Título
Database Maintenance: ReIndexing -
Descrição
Identity Manager Database Maintenance best practices: ReIndexing
-
Resolução
#1 For tables that are less than 1GB, or have less than 1 million records, there is a built-in scheduled task called "Rebuild table index".
The job runs nightly, if needed reconfigure its running schedule to run more often.
#2 For larger tables (more than 1GB, or have more than 1 million records), there is no built-in task.
As per the official documentation:
"Reindexing of tables does not take place anymore if they are larger than 1 GB or have more than 1 million data records. Maintenance of these tables must be performed by the database administrator within maintenance periods."
https://support.oneidentity.com/technical-documents/identity-manager/9.0%20lts/operational-guide/10#TOPIC-1846406
This falls into the general system maintenance and should be discussed with a Database Administrator.
Additionally, here are some resources which can help on how to run these reindexing maintenance tasks:
https://learn.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver16
https://www.sqlshack.com/how-to-identify-and-resolve-sql-server-index-fragmentation/