During index rebuilds through Maintenance Task in SQL Server 2014, do we need to apply Keep Index Online while re-indexing option in the Maintenance Wizard ?
Rebuilding Index in SQL Server 2014
indexsql server 2014
Related Question
- Sql-server – Which index types do not support online index rebuilds
- SQL Server 2014 – Transaction Log Backup Fails
- Sql-server – Index Rebuilding Log File Growth
- Sql-server – SQL Server 2014 Authentication
- Sql-server – Do I really need Re-Build Index Task in SQL Server all the Time
- Sql-server – SQL Server 2014 change license key
- SQL Server 2014 – Edition Downgrade Guide
- Patching SQL Server 2014 vs SQL Server 2014 Express – Comparison
Best Answer
Only you can answer that question.
The option will make the index rebuild operation an online operation. See Perform Index Operations Online. There are certain limitations and restrictions, I recommend you read the link above and Guidelines for Online Index Operations as well. To call out a few issues, online operations have licensing edition restrictions, they consume more disk space, they take longer, and they pin the log from shrinking. However, they do allow for the application to continue to function online while the rebuild is ongoing. So, as you see, only you can answer what you need. Take the time, study, and make an educated decision.
Also, is very unlikely that you need to rebuild indexes for maintenance. Have a look at SQL Server Index and Statistics Maintenance.