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 |
|
julie
Starting Member
1 Post |
 Posted - 2009-05-08 : 08:29:41
|
| Hi!I have 16GB RAM memory on db server and want allocate at least 14GB to SQL server, but the SQL server doesn't allow to set more than 2GB to it.I've tryed go through server properties -> memory and set max memory to something more than 2GB - doesn't work.I've tryed run script:sp_configure 'show advanced options', 1RECONFIGUREGOsp_configure 'awe enabled', 1RECONFIGUREGOsp_configure 'max server memory', 6000000000RECONFIGUREGOThat doesn't work either for values more than 2GB.Does anyone know how to encrease the memory usage for SQL server or if it's significcant question to sql server performance? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-08 : 09:16:17
|
| Enable /PAE Extension in boot.ini file and then enable AWE. Then set max and min memory. Give privileges to 'Lock in pages in Memory'.Restart your server and you should be good. |
 |
|
|
|
|
|
Set max memory more than 2 GB for SQL Server 2005