Rebuilding Indexes online in MS SQL 2005 portion of the database

  • 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

  • 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