LOCATE THE ERROR (USUALLY HIGHLIGHTED IN RED) WITH THE TEXT ’TRACE...

3. locate the error (usually highlighted in red) with the text

’trace error text’.

Locks, Blocking, and Deadlocks

Concurrency control is a vital part of any relational database management system

and in SQL Server this is implemented primarily through Locking. Locking

involves reserving resources (usually data pages) for a particular purpose; this can

affect the availability of those resources. When a single task reserves lots of resources

or runs for an excessive time blocking can occur, which affects system performance.

Deadlocks are a situation when two tasks each want to reserve a resource that the