Hello,
I would like to know the amount of free space I need to reindex a clustered
index. For a clustered index using 100 GB for example, how much data free
space I need ? (I am not talking about the transactional log) ?
Thanks in advance,
Regards,
VincentVincent
100 GB *2= 200 GB
"Vincent D." <VincentD@.discussions.microsoft.com> wrote in message
news:8E183CCA-3E97-4BC7-9A3A-D118682B20FB@.microsoft.com...
> Hello,
> I would like to know the amount of free space I need to reindex a
> clustered
> index. For a clustered index using 100 GB for example, how much data free
> space I need ? (I am not talking about the transactional log) ?
> Thanks in advance,
> Regards,
> Vincent|||Are you saying that you have a table with a clustered index, and that index tree (which contains the
data) is using 100GB. For that you will need somewhere around 120 GB free space in the database to
rebuild the index. I.e., the size of the index plus some.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Vincent D." <VincentD@.discussions.microsoft.com> wrote in message
news:8E183CCA-3E97-4BC7-9A3A-D118682B20FB@.microsoft.com...
> Hello,
> I would like to know the amount of free space I need to reindex a clustered
> index. For a clustered index using 100 GB for example, how much data free
> space I need ? (I am not talking about the transactional log) ?
> Thanks in advance,
> Regards,
> Vincent|||> Are you saying that you have a table with a clustered index, and that
> index tree (which contains the data) is using 100GB. For that you will
> need somewhere around 120 GB free space in the database to rebuild the
> index. I.e., the size of the index plus some.
To be safe, I would usually ballpark at 1.5x the index size.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment