September 23, 2010 at 5:24 am
Hi
Is it good to do index rebulid with online option when production is going on. Is there any impact?
Kindly let me know if there is any impact.
We are using Sql server 2005 standard edittion.
Thanks in advance....
September 23, 2010 at 6:37 am
yes. there is a performance hit.
September 23, 2010 at 6:43 am
you first need to analyse your index fregmentation,
in general if fregmentation is less than 30 then reorganize is preferred else rebuild.
online = on is mainly provided from 2005 onwards to make table available for operation. But it will affect the performance or not, depends on the number of records in tables.
----------
Ashish
September 23, 2010 at 4:09 pm
oneline rebuilds does not work on standard edition, only enterprise edition!
in order to rebuild the index it needs to create locks....anytime you rebiuld you are dropping and rebuilding the index in the background...
do reorg as often you can with any luck this will control the index as much as possible so that your rebuild are less oftern
September 24, 2010 at 12:05 am
Thanks for replay.
Can you please suggest me which is the best time for rebuilding indexes for standard edittion (sqlserver 2005).our production time is 5.30am to 11.30pm
September 24, 2010 at 1:38 am
our production time is 5.30am to 11.30pm
if you have maintenance window available between 11.30pm to 5.30 am, then I will suggest check the job running on server and find the window where you can schedule this activity.
You can prioritise your job schedules and I will suggest to give this job a high priority after full backup. And better to rebuild instead of reorganize.
----------
Ashish
September 25, 2010 at 12:04 am
Thanks for your great support...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply