Posted by kmounkhaty@yahoo.com on 11/17/05 18:19

Hi Guru,

My profiler trace does not display SP:CACHEMISS event, even thought I
drop store proc, clear both data cache and buffer cache but still does
not work.

Every thing works fine like: cachehit,
cacheinsert,cacheremove,executecontexthit etc...

Is there any special option that I need to turn it on?

Please help,

Thanks,
Silaphet,

• Next in forum: stored procedure with array of parameters
• Prev in forum: Re: Query returning 1.7million records slow
• Thread view: HIT and MISS

[Reply to this message]