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 |
|
rspinell
Starting Member
36 Posts |
 Posted - 2009-01-29 : 15:11:29
|
| I'm very confused by something that should be pretty simple. I have SQL 2005 Standard installed on Windows 2003 Standard server with 4GB of ram. I launch SQL Server Management Studio, click on General and it says memory is 4095MB, so far so good. I click on memory and it's set minimum server memory (in MB) to 0 and maximum server memory (in MB) to 2147483647. What should i have the maximum server memory (in MB)set to ? I also see in the errorlogs a line saying: Set AWE Enabled to 1 in the configuration parameters to allow use of more memory. I thought AWE is for machines with more then 4GB ?Thanks you |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-29 : 15:26:26
|
| Is it 32-bit ? Also What does Total Server Memory and Target Server Memory say in Perf mon? |
 |
|
|
rspinell
Starting Member
36 Posts |
Posted - 2009-01-29 : 15:29:05
|
| Its 32 bit.Total Server Memory (KB) = 1620224Targer Server Memory (KB) = 1620224Thank you. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-29 : 15:37:08
|
| Then SQL Server is not even consuming 2 GB. |
|
|
|
rspinell
Starting Member
36 Posts |
Posted - 2009-01-29 : 15:51:19
|
| So just leave the settings as it ? Should I enable AWE ? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-29 : 15:57:42
|
| Why you need AWE when you only have 4GB Ram for the box? If you need 3GB out of 4GB,You need to use /3GB switch.Leave it alone for right now. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-01-29 : 16:04:53
|
| And if my memory serves me correctly, the account running SQL server should have "lock pages in memory" rights assigned to it.Terry-- Procrastinate now! |
|
|
|
rspinell
Starting Member
36 Posts |
Posted - 2009-01-30 : 14:21:13
|
| Thanks guys. I'm going to leave it the way it is.If AWE is enabled the account running SQL does need to have the "lock pages in memory" rights assigned to it. I have another server that has SQL 2005 Enterprise installed with AWE enabled on it. I'm running SQL 2005 using the system account which already has the "lock pages in memory" rights assigned to it, so I didnt' have to do anything special once I enabled AWE on that box. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-30 : 14:23:01
|
| Correct. |
|
|
|
|
|
|
Memory on server with 4GB