Thanks for the articles.
However, when I run the same SP a couple times, I see a cache miss right after cache hit and the usecounts in syscacheobjects does increase.
Everytimes I run the sp, a cachemiss will happen before the cache hit
Could you explain?
Here is my example copied from BOL
IF OBJECT_ID ( 'HumanResources.uspGetAllEmployees', 'P' ) IS NOT NULL
DROP PROCEDURE HumanResources.uspGetAllEmployees;
CREATE PROCEDURE HumanResources.uspGetAllEmployees
SET NOCOUNT ON;
SELECT LastName, FirstName, JobTitle, Department