SharedResource
IS-IT--Management
I have a 64-bit Quad Core Windows Server 2008 12GB of RAM with SQL Server 2008 (RTM) - 10.0.1600.22 (X64) installed, I’m having troubles at discovering the best settings for memory allocation my current settings are;
Use AWE to allocate memory = No
Minimum server memory(in MB) = 0
Maximum server memory (in MB) = 9216
Index creation memory (IN kb, 0 = dynamic memory) = 0
Minimum memory per query (in KB) = 1024
Any help would be appreciated.
Use AWE to allocate memory = No
Minimum server memory(in MB) = 0
Maximum server memory (in MB) = 9216
Index creation memory (IN kb, 0 = dynamic memory) = 0
Minimum memory per query (in KB) = 1024
Any help would be appreciated.