Friday, February 17, 2012

DB LOCK

Comming across the [BULK-OP-DB],[BULK-OP-LOG] , locks in the database and there is no database backup job running. Auto stats update is set to off. Auto shrink is also set to off.
Can someone shed more light on this ? and its implications on performance '
Thanks !![BULK-OP-LOG]
Lock acquired on a transaction log to synchronize certain bulk (non-logged)
operations.
* If the BULK-OP-LOG lock is LCK_M_X (exclusive), cause may be
database/file/log backup or incremental db backup
* If the BULK-OP-LOG lock is LCK_M_S (shared), cause may be tran log
truncation, nonlogged bulk insert/bcp/select into, or text modification
operations
* If the BULK-OP-LOG lock is LCK_M_U (update), cause may be add file, drop
file, shrink file/db, or create filegroup
* If the BULK-OP-LOG lock is LCK_M_NL (NULL), cause may be dbcc
checkalloc/dbcc checkdb, create index, grow file, or modify file
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

No comments:

Post a Comment