I am digging into
sys.dm_tran_locks and have found a single, persistent X lock of
resource_type = APPLICATION that looks odd. The database which on which the lock exists is rarely used. The
resource_description tells me it's db_owner and the naming convention looks to be related to our replication processes.
I would like to know if this is normal behavior and nothing to worry about or if I need to dig deeper to remove the lock.
(We are experiencing a variety of intermittent performance issues on this server and have yet to determine why - I have no reason to think this is related, but I did want to mention it.)
EDIT - I would also like to know what a lock on APPLICATION is - the MSDN descriptions are vague to me...