2012年2月24日星期五

Disabling cache

One of the tables in my DB has a BLOB field that retrieved quite rare, so I
do not really need to have it in cache and would prefer to keep in the RAM
cache more useful data instead. Is it possible to disable caching of BLOB
values?
--
Message posted via http://www.sqlmonster.comHi
There is no way to turn it off, but since it is rarely used, it will fall
out the cache very quickly as SQL Server is very good at tuning it's cache.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Alex via SQLMonster.com" <no@.spam.pls> wrote in message
news:58af54c993dcc@.uwe...
> One of the tables in my DB has a BLOB field that retrieved quite rare, so
> I
> do not really need to have it in cache and would prefer to keep in the RAM
> cache more useful data instead. Is it possible to disable caching of BLOB
> values?
> --
> Message posted via http://www.sqlmonster.com

没有评论:

发表评论