Jay's Blog

[coding, debugging, and troubleshooting with Microsoft Technologies]

Browse by Tags

Tagged Content List
  • Blog Post: Orphaned Locks - Idle Session - and XACT_ABORT

    Sometimes you might see a situation where a session is holding locks, blocking other sessions for an extended period of time, but does not have an active request and appears to be Idle.  This can happen in a few different scenarios, but here we’ll outline one scenario and how being sure to use XACT_ABORT...
Page 1 of 1 (1 items)