Description
After you have upgraded to the 12.4 version of the Enterprise Vault server software, when you run the Start-EVDatabaseUpgrade cmdlet to upgrade the Enterprise Vault databases, the database upgrade process can take a long time. This happens if there are too many entries in the AuditTrail table in the Enterprise Vault audit database.
In Enterprise Vault 12.4, database indexes have been added on a few columns of the AuditTrail table to allow users to retrieve information from the Enterprise Vault auditing database using the OData web service. The SQL server may take a long time to add the indexes.
For 10 million rows, the database upgrade process takes approximately 2 minutes. For 1 billion rows, the process can take between 3 to 4 hours.
The AuditTrail table can have a maximum of 2 billion rows. In this case, the duration of the upgrade process may take up to 6 to 8 hours.
The duration of the database upgrade process also depends on any one or both of the following conditions:
- The type of data in the database, whether xml or plain text. If the database has more xml entries than plain text items, then the upgrade will be slower.
- The Enterprise Vault environment such as the hardware configuration, any network latency issues, and so on.
Was this content helpful?
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.