Enterprise Vault maintenance on SQL Server which cause outage ?
- 11 years ago
If you keep the EV services running, there are chances that SQL Database table indexes might not rebuild. Because services may lock some of the table indexes. In that case, running maintenance to reduce the fragmentations will not give you better results.
- 11 years ago
Hi John,
Getting that SQL maintenance right will definitely help. I have seen dramatic improvements in archive rate after an SQL clean up. EV is hugely dependent on SQL, if your SQL is not flying, neither will EV. follow the recommendations in tech74666, or even get a professional DBA to assist, it is well worth the effort.
Use the SQL PActivity Monitor to see how it is doing.
http://msdn.microsoft.com/en-us/library/cc879320.aspx
- 11 years ago
Hi John,
Here are two very well-known sources that should help.
http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
http://sqlfool.com/2011/06/index-defrag-script-v4-1/