April 5, 2011 at 8:57 am
Hello, I am trying to check if my SQL Server setting are correct:
I have AWE checked
min 250 MB
max 2147483647 MB
Index creation 0
Minimum memory per query 1024 KB
Thank you
April 5, 2011 at 11:38 am
Is it a 32bit or 64bit server? How much memory does the server have? Are there any other apps on the server?
April 5, 2011 at 12:47 pm
Is it a 32bit or 64bit server?
32 bit
9.00.4053.00SP3Standard Edition
How much memory does the server have? 12G of RAM
Available Physical Memory6.07 GB
Are there any other apps on the server? NO
Operating System5.1.2600
April 6, 2011 at 5:50 am
AWE should be enabled as you've got a 32bit server. You'll need to leave 2 or 3 Gb for the OS to use, so the maximum memory setting for SQL should be around 9Gb
April 6, 2011 at 7:19 am
Hello, I am trying to check if my SQL Server setting are correct:
How much memory does the server have? 12G of RAM
Available Physical Memory6.07 GB
AWE should be enabled as you've got a 32bit server.
Yes it is checked
You'll need to leave 2 or 3 Gb for the OS to use, so the maximum memory setting for SQL should be around 9Gb
Are you saying I need to change it from max 2147483647 MB
to 9GB?
Thank you
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply