On SQL Server, blocking occurs when one process azure video
dp-300-database-admin-assoc video for on SQL Server, blocking occurs when one process holds a lock on a specific resource (row, page, table, database), and a
Answer
Full Certification Question
On SQL Server, blocking occurs when one process holds a lock on a specific resource (row, page, table, database), and a second process attempts to acquire a lock with an incompatible lock type on the same resource. Typically, locks are held for a very short period, and when the process holding the lock releases it, the blocked process can then acquire the lock and complete its transaction. Locking is normal behaviour and happens many times during a normal day. Which are types of performance issues that can be caused by blocking? (Select two)