Transaction isolation level escalation; does it happen?
Recently I was trying to track down a deadlock situation in production that was happening more than I would like (out of about 4,000 calls per day this stored procedure was deadlocking about 10-15 times). The odd thing I noticed was that the isolation level on the connection was serializable…on a select procedure. My thought… Continue reading Transaction isolation level escalation; does it happen?