SQL Server Performance Forum – Threads Archive

24×7 operation…how do you reindex??

Just curious for those who are running 24×7 operations. How do you find the time to reindex your tables? Do you do anything different from the standard reindex job in the plans?

In any case try to get window from business for such operation, as its a 24/7 application. We do have a weekly housekeeping job which run on sunday early hours where traffic is less compared. Ensure update stats, data archiving is in place if the table is fragmented and heavy inserts/updates involved. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

So you don’t do an optimization reindex weekly?

you can always use INDEXDEFRAG, it is an online operation.

If you can’t get a window, then use INDEXDEFRAG like bambola suggests. While it won’t do a perfect reindex, it is better than nothing and its impact is much less that a full reindex. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

We do perform optimization reindex during that less hour traffic without any issues.
If the Tlog size is not an issue then follow as suggested by Bambola to use INDEXDEFRAG. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>