Home Forums SQL Server 2005 Administering BLOCKING CAUSED BY REORGANIZE OF INDEX JOB IN SQL SERVER 2005 RE: BLOCKING CAUSED BY REORGANIZE OF INDEX JOB IN SQL SERVER 2005
John Mitchell-245523
SSC Guru
Points: 148809
More actions
September 30, 2013 at 6:57 am
#1654534
Yes, but how do you know it's the ALTER INDEX...REORGANIZE statement that's doing the blocking? The code you posted does more than that.
How long does the blocking have to last before the alert is sent?
John