I'm managing a database where I noticed lock type APP. Never heard of it, could not find anything in BOL, googled the internet and found something about sp_getapplock and sp_releaseapplock. Looked up where these procedures are used in the database, and they are used a lot.
Question: is there any reason why one would use this locktype over the standard locks in SQL Sever? I understand you can lock a specific resource this way. As far as I ca tell no database resources are locked in my situation, but I wonder what would happen if something went amiss and the locked resource is not released.
The database(s) where this situation occurs are BizTalk databases, it is very likely that these locks are part of the BizTalk apl. OS is W2000 + latest sp, DBMS is SQL Server SE + sp3a.