Read KILL WITH STATUSONLY rollback estimates, confirm the target session, avoid repeated kills, and account for accelerated recovery.
SQL SERVER – Linked Server Error – Msg 3910 – Transaction Context In Use By Another Session
In this blog, I would share my understanding and the solution of Linked Server Error – Msg 3910 – Transaction context in use by another session.
Archiving Old Rows to a History Table in Small Batches
Make archiving old rows atomic with DELETE OUTPUT, preserved source identifiers, bounded batches, reconciliation, and a job time limit.
How to Measure Transactions Per Seconds in SQL Server? – Interview Question of the Week #262
Question: How to Measure Transactions Per Seconds in SQL Server?
I have updated the script for this for Comprehensive Database Performance Health Check.
Application Locks With sp_getapplock: One Job at a Time
Use sp_getapplock to serialize a job, compare transaction and session ownership, handle return codes, and inspect a two-session test.
Counting Locks per Session With sys.dm_tran_locks
Count locks per session by resource and mode, connect open transactions, and recognize escalation while keeping snapshot limits clear.
SQL SERVER – Simple Example of READPAST Query Hint
The required was very unique and we were able to solve the problem with the help of READPAST query hint. Comprehensive Database Performance Health Check