asked
Effect on indexes of mirroring failover
Hi, Do I need to rebuild indexes after mirroring failover or just reorganize? What is the best for performance. Thanks, Sam.
You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
You do not need to do index maintenance after a failover as a normal procedure.
The decision to rebuild or reorganize is probably independent of mirroring. It's more to do with the level of fragmentation of the physical data (downtime might come into it too). Microsoft's recommendations are [here][1]. In summary (and probably oversimplifying things): 0-5% do nothing. 5% to 30% reorganise 30% + rebuild. Ola Hallengren's index maintenance scripts are highly rgarded and can be found [here][2]. [1]:
https://msdn.microsoft.com/en-us/library/ms189858.aspx [2]:
https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
21 People are following this question.
