Post reply

Rebuilding Index and Changing Fillfactor is eating all my available disk space

  • February 2, 2006 at 12:23 pm

    #189070

    This is a clustered index with a fillfactor set at 90.

    I'm running the following in QA

    DBCC DBREINDEX (MYDB.DBO.TABLE', PK_TABLE, 1)

    Running the DBCC REINDEX in Qa, the mdf file has grown 10 gb and still growing, the ldf has grown 12 gb and is still growing. 

    Is there another way to do this that doesn't consume so much disk space?

  • February 2, 2006 at 1:55 pm

    #618505

    how often are you dumping the transaction log?

    have you ever attempted to shrink the database files?

    DBCC SHRINKFILE /* for the log file */

    get the file id by using sp_helpfile

    DBCC SHRINKDATABASE /* for the data file */

    I use the TRUNCATEONLY option...

    hope this helps...

    Regards,

    Joe Burdette
    hanesbrands.com

  • February 2, 2006 at 2:09 pm

    #618512

    along those lines, another thing you might look at is the following command:

    dbcc sqlperf (logspace)

    you might be surprised at just how much space you have allocated, that is NOT being used...

    Regards,

    Joe Burdette
    hanesbrands.com

Viewing 3 posts - 1 through 2 (of 2 total)

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