SQL Server Performance

slow dbcc dbreindex on sql7 with very large table

Discussion in 'Performance Tuning for DBAs' started by tgeorge, Sep 5, 2007.

  1. tgeorge New Member

    I am new to sql. We have a legacy applicatin requiring sql 7.
    We do a weekly reindex on all tables that takes about 7 hours! (around 300gb af active tables)
    One table is 47gb of data. The indexs take up 13gb
    We have very fast hardware, running w2kas
    I can do a table scan with something like select count(*) or showcontig in around 3 min (around 300mb/s sustained)
    but when it comes to reindexing, after the first ~9gb, it will drop from 300mb/s down to about 20mb/s and take around 158 min :-(
    I am using filemon and processexplorer to monitor and nothing looks strange. (other than the slow down)
    The file is defragmented. The table is in its own filegroup and the indexes are in their own filegroup.
    Any suggestions of where to look or troubleshoot.
    Thanks, Trent
  2. satya Moderator

Share This Page