DBCC INDEXDEFRAG being canceled by timeout ???
-
For the third week in a row , my maintenance script has been canceled !?!
This maintenance script just loops my tables and performs the indexdefrag.
it goes like :
...
Print '** ' + convert(char(23),CURRENT_TIMESTAMP,121) + @CmdRowInfo + ' -- DBCC INDEXDEFRAG ([Mydb],'[MyOwner].[mytable]',1)'
DBCC INDEXDEFRAG ([Mydb],'[MyOwner].[mytable]',1)
This results in ...
** 2005-03-31 13:14:17.840 -- ixRows [6942311] -- DBCC INDEXDEFRAG ([Mydb],'[MyOwner].[HistoryMainline]',1)
DBCC: Compaction phase of index 'MyDb.MyOwner.HistoryMainline' is 38% complete.
DBCC: Compaction phase of index 'MyDb.MyOwner.HistoryMainline' is 92% complete.
DBCC: Defrag phase of index 'MyDb.MyOwner.HistoryMainline' is 18% complete.
DBCC: Defrag phase of index 'MyDb.MyOwner.HistoryMainline' is 37% complete.
DBCC: Defrag phase of index 'MyDb.MyOwner.HistoryMainline' is 63% complete.
DBCC: Defrag phase of index 'MyDb.MyOwner.HistoryMainline' is 87% complete.
Query cancelled.
This happens after 45 minutes !
Am I hitting a default treshhold ?? (not documented in BOL for indexdefrag ?)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Don't know if it helps in your case, but here goes:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
Btw, looks like perfect weather for a ride.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Also, because you are using index defrag you are fortunate in the fact that everything that has been done to the point in time that it timed out is still there (nothing was rolled back).
I know it doesn't help your problem but maybe Frank's email can help with that
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply