Index Rebuild on database

by user9394033   Last Updated July 03, 2018 17:06 PM

Current Environment 2 Node Always on Active/Passive, Recovery Mode - Full

  • Database Size 350 Gb
  • Index Size 320 Gb

Please advise how much free space I need for the below:

  1. Drive for the mdf Files
  2. Drives for the ldf files
  3. Temp Db files

I will be using Ola Script and I have around 63 Indexes that will need Index Rebuild. Please advice whether the same free space should need to be provided on the passive node as well

Related Questions

Ola Hallengren Index Maintenance on Large Databases

Updated December 04, 2017 21:06 PM

Filtered index not chosen, and rejected with hint

Updated December 04, 2018 19:06 PM