October 18, 2007 at 12:44 pm
Is it possible to tell SQL Server what to cache? I was told by someone that I could use a query hint to tell query not to cache it's results. I've done some research and do not see any query hint that could do that. It also seems to me that SQL Server decides what it's going to cache and that it does not cache query results, rather it caches execution plans, tables and views. Can anyone give me some information or let me know of a good source that explains SQL Server caching.
Thanks!
Wendy Schuman
October 18, 2007 at 1:10 pm
Results can not be cached as underlying data changes
Regarding data (buffer cache) you can not control what is cached (the minor exception is PINTABLE)
October 18, 2007 at 1:10 pm
if you do select on sys.syscacheobjects this will give you info about query plan, but besides that i think every thing is internal to Microsoft.
October 18, 2007 at 3:18 pm
That's what I thought. Thanks for your responses.
Wendy Schuman
October 18, 2007 at 8:54 pm
dots67 (10/18/2007)
Results can not be cached as underlying data changesRegarding data (buffer cache) you can not control what is cached (the minor exception is PINTABLE)
PINTABLE is ignored in SQL Server 2005.
Eddie Wuerch
MCM: SQL
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply