reorganize

  • hallo

    which may impede reorganize task?

    tables due to blocked user software?

    thanks for an answer

    regards gg

  • If there are operations already being performed on those tables at the time you start the rebuild / reorganize, then you will see a delay. Rebuilding and reorganizing also will cause some blocking and you will take a performance hit while the operation is running.

    You should run these types of activities during off hours and in a maintenance window.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

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