June 25, 2014 at 5:05 am
Hi All,
I have no experience with rebuilding indexes online, so i would like to know if i need to know beside these;
A) Before
1) Check disk if there is enough space or not
B) While executing rebuild
1) monitor log size
2) have script that backup log
3) DBCC loginfo
4) check standby database whether log is applied or not
C) After
1) update statistics
June 25, 2014 at 5:31 am
You do need to monitor the amount of space taken up by the log. You should also monitor disk space in the space where the index is stored and in tempdb. Do not update the statistics after an index rebuild. A rebuild does a full scan statistics update as part of it's process. You doing a stats update either replaces a full scan with a sampled scan or, it just does the full scan again costing extra processing and resulting in nothing at all.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
June 25, 2014 at 6:03 am
Thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply