Veeam Backup & Replication – Microsoft SQL Server Index and data pages can experience internal fragmentation. Index and table structures can experience logical scan and extent scan fragmentation periodically check index fragmentation of the VSPC database
The most sensitive tables for index fragmentation are:
VeeamBP. ObjectEntityPropertyValue
VeeamOD. ObjectEntityPropertyValue
VeeamBP.ObjectEntity
VeeamOD.ObjectEntity
Rebuild vs Reorganize Indexes:
Please note that rebuilding indexes is a heavy task that can take a lot of time additionally online indexing can only be done with the Enterprise Edition of Microsoft SQL Server. In other editions of the SQL Server only offline indexing is available meaning tables having their indexes rebuilt will be locked during the rebuild operation. Reorganizing the index on the other hand is less heavy an operation and can be done online with all editions generally speaking reorganizing indexes is preferable to rebuilding when possible
SQL Server – Perform index operations online – Use SQL Server Management Studio