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

Question

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

Dan121

SSCommitted

Points: 1616
More actions
August 12, 2014 at 6:26 am

#289028

Hello all,
GO
***************************************************************************

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

Dan121 SSCommitted Points: 1616 More actions · Answer 2

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)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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

Dan121 SSCommitted Points: 1616 More actions · Answer 4

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?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

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

Dan121 SSCommitted Points: 1616 More actions · Answer 6

'Ola' scripts are very complicated. Thank you for valuable time sir.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

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