Hi all
Recently my re-index job failed with an error of Lock request time out period exceeded. I am assuming what happened was that the re-index job was unable to get a lock on the table during the rebuild and so timed out.
Is there any way I can properly troubleshoot it other than running the rebuild again and profiling the locks on the table during that period, to see what was causing the lock? Doing the profile has no guarantee that I will find the problem as this has been successful in the past
Thanks for any suggestions.