Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [awe]

12 questions
4
votes
3 answers

How much memory can SQL Server 2005 x86 use when installed on Windows Server 2008 x64?

If I install SQL Server 2005 x86 on Windows Server 2008 x64 how much memory will SQL be able to use be default? How much after setting SQL server's AWE switch? This post talks about using /3gb, /PAE, and AWE to utilize SQL Server 2008 x86 memory…
Chris Magnuson
  • 3,701
  • 9
  • 40
  • 45
4
votes
2 answers

32bit SQLServer with AWE NOT enabled. Buffer Cache Hit Ratio High, Disk Read Queue VERY HIGH, WHY?

We have a "SQLServer 2005 SP3 32bit Enterprise Edition" running on a 32 bit Windows 2003 32bit Enterprise Edition 12GB RAM with AWE enabled using RAID5(5 pysical disks). We tuned AWE to enabled and restart sqlserver this afternoon after work, hope…
chenwq
  • 43
  • 3
2
votes
2 answers

Do I need to disable AWE in SQL Server 2000 if I need the memory for something else?

I've got a SQL 2000 installation on which I've enabled AWE to address additional memory. I'm in the process of migrating to SQL 2005 and the majority of the memory will now be needed for the 2005 instance. Can I leave 2000 with AWE set up, or should…
Robin
  • 807
  • 3
  • 11
  • 19
2
votes
2 answers

SBS Server 2003 (32 bit) - SQL + Exchange - is AWE useful?

We have an SBS server running SQL Server 2005 and Exchange, that is notoriously tight on memory. (It's a battle between the sql and exchange). It's not the time yet to replace it completely, but I wonder if stocking up to 8GB (the maximum the board…
peterchen
  • 185
  • 2
  • 3
  • 15
2
votes
2 answers

SQL 2008 R2 on W2K3 Enable AWE (Address Windowing Extensions)

Hi I have a Win 2K3 with 6 gigs of memory. I had 3 gigs, and then added 3 more. However Windows won't recognize more than 4 Gigs as its a 32 bits machine. What do I have to do to make things work? I've two sql instances and set SQL Maximum memory…
Gabriel Guimarães
  • 425
  • 5
  • 18
1
vote
1 answer

How to use AWE for Windows Server 2003 (32-bit) and SQL Server 2005 (32-bit)?

The server is Windows Server 2003 SP2 (32-bit), running SQL Server 2005 SP3 (32-bit). I believe the server has 4 GB of physical RAM. The machine has crashed twice in the last week and it is a production machine. From what I understand, it has AWE…
user717236
  • 255
  • 1
  • 4
  • 16
1
vote
3 answers

Sql Server 2005 and AWE

we have SQL Server installed on a Windows Server 2003 with 2GB of memory. Would it help if we enabled AWE? Or do we have to add more memory and then enable AWE? Thanks
user53189
  • 101
  • 4
0
votes
1 answer

windows 2008 and sql 2008 AWE memory

We have a development server running windows server 2008 enterprise (x86) with SQL Server 2008 Developer (x86) installed. The box has 8GB of ram installed, which windows sees. In order to get SQL Server to use memory above 2GB do I need to enable…
NotMe
  • 3,772
  • 7
  • 30
  • 43
0
votes
2 answers

Sql 2000 and AWE

I have a weird problem. I enabled AWE on a Sql 2000 sitting on a Windows 2003 server. The server has 20 gigs of memory but when i enable AWE sql process is showing as having only 128 MB. From perfmon however looks like a bit part of memory is being…
Paul
  • 714
  • 2
  • 6
  • 19
0
votes
2 answers

AWE turned on but still not using memory

I do have a server 2008 64 running a SQL server 2005. I do have 8GB on the server and I want SQL to use most of the memory on that server. I have turned the page-locking on for the account and also turned AWE on. See the result below: Configuration…
Ridvan
  • 1
0
votes
2 answers

como se que esta funcionando AWE?

Tengo un servidor con 8GB de RAM de 32 bits, instale windows server 2003 enterprise y sql server 2005 enterprise, el Sistema Operativo reconoce los 8GB, pero el Sql Server solo usaba 1.6 GB de memoria, entonces agregue al boot.ini el parametro /PAE…
adan851018
  • 3
  • 1
0
votes
1 answer

SQL Server 2005 Lock Pages in Memory on 32-bit system

On a 32-bit Windows Server 2003 Standard Edition SP2, I'm debating the pros and cons of /3gb + AWE + Locked Pages for SQL Server 2005 Standard SP3 CU4. The system only has 4GB of physical memory, however the developer's IIS service seems to be…
califguy4christ