Questions tagged [awe]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
2 answers
568 views

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 ...
4 votes
2 answers
493 views

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 ...
1 vote
1 answer
2k views

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 ...
0 votes
2 answers
187 views

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 ...
0 votes
2 answers
242 views

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,...
2 votes
2 answers
883 views

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? ...
0 votes
1 answer
202 views

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, ...
4 votes
3 answers
6k views

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, ...
0 votes
2 answers
216 views

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 ...
0 votes
1 answer
6k views

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 ...
2 votes
2 answers
304 views

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 ...
1 vote
3 answers
1k views

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