SODIMM RAM

How does the buffer pool handle low memory conditions?

(Thanks to Erik Darling for reviewing this post. Check out his training materials.) One of the bigger clichés in the data professional vocabulary (behind “it depends”) is that you always give SQL Server as much RAM as you can afford, because it’s going to use it. But what happens when SQL Server runs out of
-> Continue reading How does the buffer pool handle low memory conditions?