Post reply

drop index takes forever? any ideas

  • October 28, 2004 at 1:42 pm

    #109671

    I have a test server with the following config.

    2GB RAM , Dual 1.4 GHZ Xeon, scsi attacted local dasd. running developer edition of SS2K.  The Database is Bulk-Load recovery model.

    Execute a drop index on the 11 MIL row table takes a few seconds.

    I have a production server with the following config.

    2GB RAM, Dual 1.4GHz Xeon, 4 Drive of 50GB connected to Hitachi SAN, running the Standard edition of SS2K.  This database is in Simple recovery.

    Execute a drop index on a table with 11Mil rows takes over 1 hour.

    hmaandek

  • October 29, 2004 at 2:36 am

    #528371

    It could be that the TSQL to drop the index is being blocked by something else running against the table.

  • October 29, 2004 at 8:25 am

    #528406

    Also check to see if you auto shrink set on on the database. Sometimes these settings can cause performance problems.

  • October 29, 2004 at 11:03 am

    #528423

    no auto shrink is not on and there was no blocking taking place either.

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

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