Reorganize and Rebuild index job taking 4+ hours!!!

  • Hello all,

    GO

    ***************************************************************************

  • Any blocking? What's the process waiting for?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • where can I find that in 'view history' (log) if there was any wait or blockings? Log says:

    Message

    The job succeed. The job was invoked by schedule ......The last step to run was step 1 (DefragmentIndex)

  • I thought you meant it was still running. No, there isn't any history of that kind of thing. After the fact it's near-impossible to figure out why something ran long unless you're got a pile of custom monitoring in place.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Do you find any 'unusual' in the script? If I want to reorganize and rebuild index > 5000 pages where and how can put this filter in the script? Do you think I might help little bit?

  • To be honest, I'd say ditch your custom script and just use the one at http://ola.hallengren.com/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 'Ola' scripts are very complicated. Thank you for valuable time sir.

  • Yes they are, but they're very well tested and very comprehensive

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 8 posts - 1 through 7 (of 7 total)

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