I am currently experiencing this job getting stuck in my nightly maintenance solution -
ALTER INDEX [PK_ThirdPartySettleCalled] ON [evo_archive].[dbo].[ThirdPartySettleCalled] REORGANIZE WITH (LOB_COMPACTION = ON)
a full reindex of the table works.
but I'm using Ola Hallengren's awesome solution as I do on a number of sites that need maintenance solutions. http://ola.hallengren.com/Documentation.html and the job gets stuck in the middle of the night.
I've tested it as a single statement from within ssms with the same result, without an error I'm a little short of ideas.
Anyone experienced this issue before ?
the table is circa 300 million rows,
basically I say 'stuck' because no other processes are running in SQL server, and its been reorganising for hours with no error.
It is in the same state with 25% fragmentation or virutually 0% (tested after a full rebuild of the index)