Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Re-Index :Performance ISSUE RE: Re-Index :Performance ISSUE
Chris Harshman
SSC-Forever
Points: 42192
More actions
March 15, 2013 at 6:16 am
#1597460
To know if blocking was the issue, you would have had to check the running requests using sys.dm_exec_requests or look for waiting locks in sys.dm_tran_locks before you stopped the job. Does this job do any logging?