Compile Locks, Owner Qualification, Cache Miss

Hit and miss Or “Monitoring plan cache usage”

http://sqlinthewild.co.za/index.php/2010/07/27/hit-and-miss/

Description of SQL Server blocking caused by compile locks

http://support.microsoft.com/kb/263889

Troubleshooting stored procedure recompilation

http://support.microsoft.com/kb/243586

sys.dm_tran_locks (Transact-SQL)

http://technet.microsoft.com/en-us/library/ms190345.aspx

INF: Understanding and resolving SQL Server blocking problems

http://support.microsoft.com/kb/224453

Performance Impact of Procedure Calls without Owner Qualification

http://sqlblog.com/blogs/linchi_shea/archive/2007/06/30/performance-impact-of-procedure-calls-without-owner-qualification.aspx

SP:CacheMiss Event Class

http://technet.microsoft.com/en-us/library/ms189103.aspx

Plan Caching in SQL Server 2008

http://technet.microsoft.com/en-us/library/ee343986(v=sql.100).aspx

How to identify the cause of recompilation in an SP:Recompile event

http://support.microsoft.com/kb/308737/EN-US

SQL Programmability & API Development Team Blog

http://blogs.msdn.com/b/sqlprogrammability/archive/2007/01/16/9-0-memory-pressure-limits.aspx

Stored Procedures and Caching

http://www.sqlservercentral.com/articles/Administration/procedurecache/591/

Execution Plan Caching and Reuse

http://msdn.microsoft.com/en-us/library/ms181055.aspx