SQL Server Performance

Rebuilding Index SQL server 2000

Discussion in 'General DBA Questions' started by ananda, May 17, 2009.

  1. ananda New Member

    Hi Friends,
    I have configured database maintenance plan for rebuilding index every week sunday after complete of Full backup, so currently database size 340 GB, completing of rebuild jobs db size have been increased more than 8GB. i think this is sql server behaviour for increse db size after complete of rebuilding index.
    Is there any alternative way to prevent db size increase when complete rebuilding index? please can any one give me sloution.
  2. MohammedU New Member

    DB size may increase depending the fillfactor but you didn't mention the increase was data file or log file?
  3. ananda New Member

    Thanks for your reply......
    I have mention for rebuilding index on maintenance plan as follows.
    Reorganize data and index page
    I have mention first option - Reorganize pages with the original amount of free space.
    In second option - change free space per page precentage to.
    please tell me , If i choose second option how much precentage mention for change free space and Fillfactor values , currently db size 340 GB, this jobs runs every week on sunday 3PM after competed of full db backup.

Share This Page