Hello!
Every time I execute stored procedure I see SP:CacheMiss and
SP:CacheHist events in Profiler. Stored procedure is owner qualified. I am
using SQL Serve 2005 and understand that caching algorithm is probably
different from SQL 2000. I am not sure why there is always CacheMiss event.
Is this something I should be concerned about? I know that in SQL 2000 this
might be caused by not fully qualifying stored procedure, but this is not
the case with my stored procedure. Can anybody forward me to the place
explaining difference in caching between SQL Server 2000 and 2005?
Any help is greatly appreciated.
Thanks,
IgorI think I found the answer:
http://blogs.sqlservercentral.com/blogs/michael_coles/archive/2006/08/09/695.aspx
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:%23dKVMRjrHHA.1296@.TK2MSFTNGP06.phx.gbl...
> Hello!
> Every time I execute stored procedure I see SP:CacheMiss and
> SP:CacheHist events in Profiler. Stored procedure is owner qualified. I am
> using SQL Serve 2005 and understand that caching algorithm is probably
> different from SQL 2000. I am not sure why there is always CacheMiss
> event. Is this something I should be concerned about? I know that in SQL
> 2000 this might be caused by not fully qualifying stored procedure, but
> this is not the case with my stored procedure. Can anybody forward me to
> the place explaining difference in caching between SQL Server 2000 and
> 2005?
> Any help is greatly appreciated.
> Thanks,
> Igor
>
No comments:
Post a Comment