OPEN SYMMETRIC KEY command prevents query plan caching

This was quite an interesting issue. We started troubleshooting a SQL Server blocking problem due to COMPILE lock blocking. The KB Article: Description of SQL Server blocking caused by compile locks explains why COMPILE lock blocking is encountered on a SQL Server instance. Now there must be a catch here J, otherwise why would I…

4