In a previous section we learn about how to get Blocking SPs, In Todays section we seen how to identify locking .
Locking is integral part of successful transactions of RDBMS. It is important in SQL Server that transactions pass the ACID test:
- Atomic – the transaction performs in an all-or-nothing fashion
- Consistent
- Isolated – transactions are properly isolated until they’re finished
- Durable – the RDBMS will maintain a record of uncompleted transactions in the event of recovery during a failure.