SQL Server Performance

IndexDefrag And Shrink

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by travistan, May 20, 2007.

  1. travistan New Member

    Hi ,

    Do the IndexDefrag truncate the unused space of the page ? Or need to shrink the db after perform the IndexDefrag command ?

    Thanks ,
    Travis
  2. satya Moderator

    No it will not and in order to truncate the space only TRUNCATE statement or SHRINK operation will take care.

    You will be wasting system resources if you perform a defrag and doing a shrink operatons, why not set a size to transaction log in order to continue the weekly defrag without any issues.

    Fyihttp://sqlserver-qa.net/blogs/tools...server-index-optimization-best-practices.aspx on the best practices

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page