SQL Server Performance

SQL Profiler event to trace - Snapshot isolation transaction aborted due to update conflict

Discussion in 'SQL Server 2008 General Developer Questions' started by anonymous2009, Nov 8, 2011.

  1. anonymous2009 New Member

    I have this stored procedure that throws "Snapshot isolation transaction aborted due to update conflict".
    Which SQL Profiler event should I turn on to trace what actually is going on?

    Thanks!
  2. Luis Martin Moderator

  3. anonymous2009 New Member

    Thanks Luis!
  4. Shehap MVP, MCTS, MCITP SQL Server

    Indeed, This is of the common data consistency issues of transaction isolation level either it posted you an error or not posted…How ..?

    1. Since perhaps might be transaction isolation level Read or DML operate some data from a snapshot older than other DML operations carried out by other end users concurrently .

    2. In this case it read or DML operate the data entity based on old values not recent values…And this is most repeated while concurrent DML transactions

    Hence To avoid such that ,you have to supersede it by transaction isolation level read committed using row versioning

Share This Page