I have a question regarding the memory settings. I have new installs of 64bit sql server, and when I just do a default install, the Properties > Memory settings have a panel that has a checkbox to use AWE to allocate memory, and then 2 numeric boxes below, one with zero and one with 2147483647. My question is, Are the 2 boxes with the numbers related to the AWE checkbox, and is this what's used to limit the memory allocation? The reason is that this particular box is a VMWare install, and has 32g of memory allocated. There are 4 instances of SQL Server running here. Can I limit the memory used by the 4 instances, or should I just leave it and let it take what it needs. There seems to be plenty available as the instances are separated for a variety of requirements, but performance/load isn't one of them. Or should I enable this feature and just set each instance to max out at something below 8g?
Thanks for any insight
Not a downstroke, fistpicker