SQL Server Performance

dbcc indexdefrag...Need Help

Discussion in 'Performance Tuning for DBAs' started by Arman, Mar 19, 2008.

  1. Arman New Member

    Last night i run DBCC INDEXDEFRAG and after few hours it complelety fill the log file, size of log file was about 30GB.
    Any idea that what happened and how to prevent from this in future.
    Thanks
    Executed as user: ...TE 01000] (Message 0) DBCC execution completed.
    If DBCC printed error messages, contact your system administrator.
    [SQLSTATE 01000] (Message 2528)
    DBCC INDEXDEFRAG (0,database,ADJ_RECORD_NUMBER_IDX1) [SQLSTATE 01000] (Message 0)
    DBCC execution completed. If DBCC printed error messages, contact your system administrator.
    [SQLSTATE 01000] (Message 2528) DBCC INDEXDEFRAG (0,database,CC_NUM_IDX1) [SQLSTATE 01000]
    (Message 0)
    DBCC execution completed.
    If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528)
    DBCC INDEXDEFRAG (0,database,check_number) [SQLSTATE 01000] (Message 0) DBCC execution completed.
    If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528)
    DBCC INDEXDEFRAG (0,database,dispatch_number) [SQLSTATE 01000] (Message 0) DBCC execution completed.
    If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]
    (Mes... The step failed.
  2. ghemant Moderator

  3. satya Moderator

    How big is the data file?
    How many indexes are defragmenting with this statement?
    As explained by Hemant by default you will see such a change in log file size, its better to defragment required indexes.

Share This Page