Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2009-09-08 : 21:24:39
|
| Hi,I have just setup a server with Windows Server 2008 Ent. and SQL 2005 Ent. both are 64-bit editions. The server has 16 processors (4 physical quad core) and 32GB memory.This server, once complete will replace our existing 32-bit server.What do I need to do to utilize the 32GB memory in this new 64-bit server?Regards,Terry |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-09-08 : 21:36:21
|
| If you have 32GB, I would allocate 26GB for SQL Server and rest for OS.In 64-bit,you just have limit memory with max and min memory settings. Give 'lock pages in memory' privileges to SQL Service Account and restart the server. |
 |
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2009-09-08 : 21:58:04
|
| Thanks sodeepAWE doesn't apply since this is a 64-bit system, right? Just set the minimum to 0 and the max to 26GB.Priviledges for "lock pages in memory" ... I have already done this via the group olicy.Thanks,Terry |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-09-08 : 22:02:22
|
| Correct. You don't need to Enable AWE as it is 64-bit. Just set Min - 2GB and Max-26GB And you should be good. |
|
|
|
|
|
|
64-bit and 32GB Memory