Wednesday, March 28, 2012

How much space should I give to tempdb for rebuilding index?

Hi, all.
I scheduled a schedule for index rebuilding for a database which is about
60GB.
I know that tempdb is required for index rebuilding, but don't know how much
space would be adequate.
How much space should the tempdb have for index rebuilding?
Any help would be appreciated.> I know that tempdb is required for index rebuilding, but don't know how
much
> space would be adequate.
That depends on how you rebuild the index. If you use DBCC INDEXDEFRAG or
DBCC DBREINDEX, then tempdb is not used. And this is what most are using.
Below section in the updated books online has some info:
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Kim Keuk Tae" <zyuuzika@.korea.com> wrote in message
news:ODELj%230pDHA.3504@.TK2MSFTNGP11.phx.gbl...
> Hi, all.
> I scheduled a schedule for index rebuilding for a database which is about
> 60GB.
> I know that tempdb is required for index rebuilding, but don't know how
much
> space would be adequate.
> How much space should the tempdb have for index rebuilding?
> Any help would be appreciated.
>
>sql

No comments:

Post a Comment