Hi, my friends,
I have this next in a job, and it has been running fine. Typical duration of time is about 1 hour.
This last weekend, it went into a tail spin. After I canceled it, it had been running for 18 hours, and had causing other jobs to hang.
Any suggestion on where I should look for the root cause?
Also, what could be the reason(s) that the time limit of 3 hours here was not honored?
Thanks!
EXECUTE dbo.dba_indexDefrag_sp
@executeSQL = 1
, @printCommands = 1
, @debugMode = 1
, @printFragmentation = 1
, @forceRescan = 1
, @maxDopRestriction = 1
, @minPageCount = 8
, @maxPageCount = NULL
, @minFragmentation = 10 --pick the higher ones first, then down to 10
, @rebuildThreshold = 30
, @defragDelay = '00:00:05'
, @defragOrderColumn = 'page_count'
, @defragSortOrder = 'DESC'
, @excludeMaxPartition = 1
, @timeLimit = 180 --min = 3 hours
, @onlineRebuild = 0
/* 1 = online rebuild; 0 = offline rebuild; only in Enterprise */
, @database = 'mydb';