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?

Thanks!

T.

Here is my example copied from BOL

USE AdventureWorks;

GO

IF OBJECT_ID ( 'HumanResources.uspGetAllEmployees', 'P' ) IS NOT NULL

DROP PROCEDURE HumanResources.uspGetAllEmployees;

GO

CREATE PROCEDURE HumanResources.uspGetAllEmployees

AS

SET NOCOUNT ON;

SELECT LastName, FirstName, JobTitle, Department

FROM HumanResources.vEmployeeDepartment;

GO

EXECUTE HumanResources.uspGetAllEmployees