question

Mona avatar image
Mona asked

Disk requirement for Index Build

Hi, my current database initial size is 120 GB (20 GB free space available) and I have 50GB available on disk drive, I am building indexes for this database and failed due to primary filegroup space issue. I have tried free up some space but still failing. Can some one assist me how much space needed to build index. Thanks for your help in advanced.
indexes
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nidheesh.r.pillai avatar image nidheesh.r.pillai commented ·
Hi - What drive is your primary filegroup residing? Is it the same as that drive which has 50GB of available space? What table(s) are you applying indexes to? How much data are present in them? What is the type of Index that you are creating and the data type of the key column(s) that you have chosen?
3 Likes 3 ·

1 Answer

·
Rizwan avatar image
Rizwan answered
Hi Nidheesh To estimate the size of indexes both clustered and non-clustered. Please go through the links you will get the mathematical formula ; https://technet.microsoft.com/en-us/library/ms178085%28v=sql.105%29.aspx https://technet.microsoft.com/en-us/library/ms190620%28v=sql.105%29.aspx
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nidheesh.r.pillai avatar image nidheesh.r.pillai commented ·
I think you should address the answer to the questioner, not me :-)
2 Likes 2 ·
Rizwan avatar image Rizwan commented ·
Sorry... I addressed to questioner.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.