SQL Server 2008 recommended memory configuration
Posted on 2011-05-09
Hi All, I have SQL 2008 R2 installed pretty much with the default install settings. This server is a VM on VMWware ESXi. I have 6GB of RAM allocated to this SQL VM. SQL is the only application installed.
After a few days of SQL running, SQL uses a little less than 5GB of memory.... from what I understand this is normal...leaving hardly anything for the OS. Occassionally, the server hangs and freezes up...and I'm thinking it's because SQL is hogging all the memory and not leaving any for other processes.
I know that I can set the max memory - but what is the recommended way of handling this? Is it best practice to set the max memory? or to just leave the defaults?
I'll find out shortly if setting max mem solved this particular issue.