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 |
|
benn.jacobs
Starting Member
1 Post |
 Posted - 2009-04-23 : 04:21:39
|
| Dear all,I have some issue and I’ll be happy to hear some ideas.1. I have 12GB RAM in my windows 2003 SBS server (Dell power edge 2900)2. My SQL server is SQL server 2005 Enterprise.3. I am using large DBs4. In my Boot.ini file I put the /PAE switch.When I leave the AWE options (in SQL server) unchecked I see in the task manager that “sqlserver” process allocate 1.7GB (never more than that-even if I set maximum memory 8GB in SQL properties)Now,when I checked the AWE options I see in the task manager that “sqlserver” process allocate ONLY 70MB RAM!!!Any idea?What is the recommend setting to set in Boot.ini and in SQL server (AWE) for 12GB RAM?SincerelyBenn.jacobs@gmail.com |
|
|
|
|
|
SQL server 2005