Lock:Timeout

  • Profiler has traced Lock:Timeout occuring in system processes (SPID 9 and 13) that are running Task Manager in background.

    Can anyone explain it what are happening and why? Thanks.

  • Task manager is running some job that is causing blocking.

    Look and see What jobs are running in task manager when this happened?

    Get The SQL text from your profile and it should give you an indication of which job it was (by id) which you can track down.

    Once you know what job was causing it, see what that job does, etc...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply