N/APosted on - 07/14/2011
I´m currently using a SQL Server on top of VMWARE Server with Win 2008 64 bits, with 4 GB of RAM. I´ve assigned 3 GB to SQL Server and the rest left it to OS management. But I always keep getting the impression that the box needs extra memory. Currently we´re running primarily batch processes. Are there any best practices out there regarding SQL?
How can i determine real memory needed for SQL server?
I have read your question about determining the real memory needed for SQL. I want to share with you that in windows the memory requirements can be changed from default based on the system resources. The default settings for the min server memory is set to 0 and the other one is the max server memory which is 16 megabytes.
You can set and change the default by going in to the Start Up menu and there you can alter the maximum server memory, but changing it from high to low may cause the performance to slow down a bit.