DB01LOCK & DB01

[former_member201054]

Hi,

what is the purpose of DB01LOCK & DB01.What kind of activities possible from these two.

Thanks in advance

[Former Member · Accepted solution]

Hi,

You can monitor exclusive lockwaits using DB01.

for more detail on exclusive lockwaits check Note 806342 - FAQ: Analyzing exclusive database locks on SQL Server

regards,

kaushal

[former_member201054 · Accepted solution]

Hi,

Could you please tell me the purpose of DB01LOCK

I would appreciate your help.

Thanks in advance

[Former Member · Accepted solution]

Hello Daniel,

DB01 is used for monitoring exclusive lockwaits

If a process wants to locks a database object exclusively, but this lock is prevented by a another database transaction (a 'blocking lock'), then the system blocks the lock request until the current database transaction releases the object again.This is called exclusive lockwait

Generally, the locked object is a table entry. It may also be an entire table, or a stored procedure for example.

we can monitor through DB01 and analyze further

Rohit