On SQL Server instance, Server memory options, we have the following settings:
On a typical server computer used to run other applications (not exclusively used as Database server), what will you recommend for the memory settings? Say it has 3GB RAM
asked Nov 05, 2010 at 07:37 AM in Default
The AWE is useful if your machine is 32 bit so that SQL will be able to access more than 2GB of virtual address space. I haven't usually set the min server memory in my servers but you need to set the Max memory SQL can use so that your other applications and windows will not be memory starved since SQL will grab as much as it can. Personally I leave around 2GB or 10% of your memory which ever is bigger for windows and assign the rest to SQL Server. However if other apps are running on that machine(i.e. if it is not exclusively database server) you need to decide how much your app will need by monitoring for a while.
This awesome article explains in detail your options when configuring SQL Server memory. SQL Server memory configuration
Edit: fixed broken link.
That's an unanswerable question really.
The answer really is 'as much as possible'.
However, it really does depend. If you use SQL Server only very lightly, but you have a heavy weight application running on the server, then you don't want to give SQL Server too much.
If you are processing hundreds of queries, and your other application is MineSweeper, then you will want to give SQL Server quite a lot...
answered Nov 05, 2010 at 07:40 AM
Matt Whitfield ♦♦
For a starting position I would want to leave 1GB for the OS (some are better than others and you may be OK with +- 30%) and have the remainder for SQL. If the server is running other apps too then SQL would have to have less. Start off with something you think is reasonable and then adjust according to which process needs the memory first. Then put in a PO for more RAM if its a busy/important box.
This is a good link for memory settings details http://blogs.msdn.com/b/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx
As others have stated - it depends, sorry.
Each implementation is unique and the settings will be dictated by the environment being run in.
As for the minimum setting... that is how low SQL Server will drop its memory to if under pressure from the O/S. Don't assume it is the minimum that SQL Server will start up with.
Some may slap me down for this but, you might just leave it at default and see what transpires. Consider it a baseline step.
answered Nov 05, 2010 at 08:16 AM