I am reading SQL Server lock escalation from MSDN Page about SQL Server lock escalation My question is, seems the major reason why there is lock escalation is to reduce overhead to maintain more l...

Is there any way to determine precisely why a System.Transaction TrasactionScope is being escalated to the DTC? We are hitting a bump with one of our components that seem to escalate the transactio...