Hey everyone, just a quick note on how to change the min/max memory settings on your SQL Server instance.
By design, your SQL Server service will attempt to use as much memory as it sees fit in order to avoid going back to the disk to store the data it wants to. It will instead attempt to store as much data as possible in memory.
Not setting a max limit on the amount of memory SQL Server should use can greatly negatively impact the service's performance as well as the server's performance and you may start getting memory errors such as:
Error 802
There is insufficient memory available in the buffer pool.
"Musings from a DBA in training." - Geon Bell
Showing posts with label Memory. Show all posts
Showing posts with label Memory. Show all posts
Thursday, 8 August 2013
Subscribe to:
Posts (Atom)