SQL Server constantly monitors page usage in Data cache buffers and freed pages that are not in use recently when free pages pool size drops below minimum. Any read operation that uses Data cache buffers could cause already cached pages to be freed.
>It might not apply to specific tables but to all the tables in general. But, there is a caching mechanism and I am trying to find some information as to know what could cause it to uncache everything and restart.
--sb--