• I'm working on a SQL2008 R2 Enterprise FastTrack server. Queries on this server have a tendency to display select locks at tempdb DB level with a resource type of [ENCRYPTION_SCAN].

    I have triple checked and no DB has encryption enabled; there are no encryption keys in sys.dm_database_encryption_keys.

    I don't know if the locks are having an adverse effect but I get 24 of them on a really big query which is running against one DB and joining into a big table in another DB on the same server. The locks even seem to be there when no temp objects are in use, although I guess that's due to internal temporary structures.


    Can anyone explain why these locks occur and what they are doing?


    Thank you!

    יום שישי 02 דצמבר 2011 10:15


כל התגובות