Showing posts with label Blocking. Show all posts
Showing posts with label Blocking. Show all posts
Why SQL Server SPID is blocking itself
Hi All
Issue: SPID is blocking itself
Description: On one of our server SQL 2005 i have run one maintainence (update statistics)job in morning hours on a businessday and as it should not create any issues i was monitoring server health. After executing job i found spid 64(belongs to job) is blocking itself.and after some time it went off
Subscribe to:
Posts (Atom)