January 28, 2009 at 10:08 am
What is the recommended options from BOL about the memory usage configuration of Win2k3 for sql server? (Programs or System Cache)
That configuration option can be found under "My Computer" -> "Properties" -> "Advanced" -> "Performance" "Settings" -> "Advanced" -> "Memory Usage"
I cannot find a clear documentation on it.
There is this thread that discuss a bit about it:
I've found information about that configuration for the full text engine
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ftslesld.mspx
But nothing solid about the database engine only. Someone knows?
January 28, 2009 at 11:39 am
It depends.
32 or 64bit?
Amount of memory in the machine.
What other processes might run on the machine (ie file copying, ssis packages, replication)
January 28, 2009 at 11:45 am
Most of the server are 32 bits and they should not run anything else beside SQL. No IA64 for sure at the moment.
Most of the servers will only host the SQL engine while some might have SSIS along. (Ne replication and no file copy)
Some will be in a cluster environment some don't.
The memory setup can be as few as 2 gigs up to to the maximum supported by the server.
There's multiple machine for multiple scenarios.
Thanks!
January 30, 2009 at 4:52 pm
If you aren't running programs on there go with the system cache mode.
February 3, 2009 at 6:34 am
Thank you for the answer.
Do you happen to know what windows do under the cover with memory management for both option?
February 3, 2009 at 7:25 am
That's one for people smarter than me to answer (:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply