February 11, 2009 at 7:53 am
Hi
I am Planning to rebuilding indexes on-line on my database. Is it possible to rebuilding index online only portion of the database.. Can rebuild only 25 % tables on Monday ,25% on Tuesday,25% on Wednesday and remaining on next.
Please advise me how can do this task if I have 80,000 tables in my database ..
Appreciate comments and suggestion
Thanks
Ichbin
February 11, 2009 at 10:09 am
You can definitely do this and there are invariably dozens of different possible solutions I am guessing.
I would probably create a table structure populated with the tables that you think need to be rebuilt (based on fragmentation %) and then within that table have an id, tablename, indexname, runnbr such tha the runnbr would be a value of 1-4 depending on which run you wanted it to go on. And then either through a script or SSIS package schedule the index rebuilds based on that runnbr. That would be easy enough to set up and have run, I would think and it would give you the control to determine which tables you wanted rebuild on which days and you could determine the 25% number by pretty much anything you wanted to (25% of total tables, 25% by row count, 25% by table size, etc...). Do whatever you are most comfortable with, I would say.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply