October 10, 2010 at 12:52 am
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
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
Thanks For your reply,
Task is completed.
October 12, 2010 at 2:18 am
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