How much log index rebuild will generate.I remebered reading rebuild index should generate same amount of log file as table size.But my tests are showing otherwise.We need this estimate since we are trying to build azure database indexes and it has a limitation of max 2 GB.
My database is in full recovery model.
Table Size:
log size:
from the pictures you can see log generation was very less with online index rebuild operation.Can some one correct me if i am missing anything
Aucun commentaire:
Enregistrer un commentaire