The tag has no wiki summary.

learn more… | top users | synonyms

4
votes
2answers
402 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
1answer
856 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
2answers
134 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
2answers
171 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 ...
2
votes
2answers
628 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
1answer
174 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, ...
3
votes
3answers
4k 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
1answer
5k 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 ...
0
votes
2answers
148 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 ...
2
votes
2answers
194 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 ...
2
votes
2answers
455 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 ...
1
vote
3answers
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