Post reply

Suggestion required in creating a maintenance plan

  • July 7, 2010 at 5:15 pm

    #157064

    Hi folks,

    I may be stupid but let me know If i'm. Anyway I wanna create a maintenance plan in which i wanna rebuild and reorganize the indexes. Here in my maintenance plan i wanna check the fragmentation information and if fragmentation is between 20% - 40% i wanna reorganize the index and if fragmentation is above 40% then i wanna rebuild the index and even i wanna include update statistics. Is this possible? let me know your ideas.

    I wanna schedule this once in a week.

    SAM.

  • July 8, 2010 at 9:15 am

    #1190318

    You should be able to use an Execute SQL Task to check the fragmentation amounts and then have a conditional precedent to lead up to the reorganization task. But I haven't done it in a Maint. Plan before. Our work place does a T-SQL only job where we store the fragmented index names in a temp table then reorg based on that table.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply