Reply to thread

Message: <blockquote data-quote="dm15644" data-source="post: 154919">Generally speaking, if ressources are limited one can only overcome this by sacrificing performance. Still, compared to Windows swapping because it's running out of silicon memory I would guess it's more efficient to let SQL Server swap its data to HDD because SQL should have better estimates on what data is least likely to be required in the future.(Assuming that MS have put some brains into the implementation of limiting memory usage on SQL Server.)Note: The strict answer to your question is: I don't know./jayrock</blockquote>