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
Bạn đang xem 3. - THE REAL MTCS SQL SERVER 2008 EXAM 70/432 PREP KIT- P118 DOC