Post reply

Index Rebuild

  • October 10, 2010 at 12:52 am

    #142232

    Hi DBA's,

    i have been assign a task to rebuild index's of a big table

    Total size of table:100 GB

    Size of Clustered Index: 12 GB

    Total Index Size on the Table: 22 GB

    I have 40 GB free on temp and log drive free and 60 GB on datadrive

    now i want to make sure if this is the sufficient space to rebuild index's on his table and what's the best practise.

    thanks

    Puneet

  • October 11, 2010 at 1:05 am

    #1234801

    As a best practice you can restore the backup in test environment and execute the reindex on the specified table and check if the space available in the productin is sufficient?

    Also if enverything goes well on test environment; plan on productino during off-peak hrs.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • October 11, 2010 at 1:31 am

    #1234807

    Thanks For your reply,

    Task is completed.

  • October 12, 2010 at 1:42 am

    #1235331

    My 2 cents:

    For index rebuilds, I recommend Ola Hallengrens homepage[/url]

    Best regards,

    Henrik Staun Poulsen

    http://www.stovi.com

  • October 12, 2010 at 2:18 am

    #1235340

    pujain (10/11/2010)

    Thanks For your reply,

    Task is completed.

    Puneet , Did you notice how much log drive and tempdb got eaten ? additionally did you set the sort_in tempdb = on ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 5 posts - 1 through 4 (of 4 total)

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