como se que esta funcionando AWE?

Posted by adan851018 on Server Fault See other posts from Server Fault or by adan851018
Published on 2010-12-24T01:08:24Z Indexed on 2010/12/24 2:55 UTC
Read the original article Hit count: 305

Filed under:

sql-server-2005

|

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 y en Sql Server le habilite AWE de 1GB a 5GB, despues de reiniciar el servidor el Sistema que usa la BD estaba mas rapido mejoro bastante, pero en memoria el Sql Server solo usa 100 MB, veo la cantidad de memoria usada en el Administrador de Tareas de Windows, y no se si esta funcionando AWE o que sucedio?

Rough translation:

I have a server with 8GB of RAM 32-bit, install windows server 2003 enterprise and sql server 2005 enterprise, the operating system recognizes the 8GB, but the SQL Server only using 1.6 GB of memory, then add to boot.ini the parameter / PAE and will enable AWE Sql Server 1GB to 5GB, after rebooting the server using the database system was faster, the better lot, but in memory the SQL Server only uses 100 MB, I see the amount of memory used in Manager Windows Tasks, and not if AWE is running or what happened?

© Server Fault or respective owner

Related posts about sql-server-2005

[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4

as seen on SQL Authority - Search for 'SQL Authority'
If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL Server 2005 SP4. There are many… >>> More
SQL Server 2005 - Syncing development/production databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server. My main concern is deploying schema + data updates to developer machines from the "master" development… >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More

Related posts about awe

como se que esta funcionando AWE?

as seen on Server Fault - Search for 'Server Fault'
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 y en Sql Server le habilite AWE de 1GB a 5GB, despues… >>> More
Why does my SQL Server use AWE memory? and why is this not visible in RAMMap?

as seen on Server Fault - Search for 'Server Fault'
We have a Windows Server 2008 R2 (64-bit) 8GB server where, according to Sysinternals RAMMap, 2GB of memory is allocated using AWE. As far as I understood, this means that these pages stay in physical memory and are never pushed out. This causes other apps to be pushed out of physical memory. In… >>> More
32bit SQLServer with AWE NOT enabled. Buffer Cache Hit Ratio High, Disk Read Queue VERY HIGH, WHY?

as seen on Server Fault - Search for 'Server Fault'
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 the performance will be better than old time. But… >>> More
Is AWE in SQL 2005 Ent needed on 2003 32-bit w/ 24GB?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a WS 2003 32-bit system running SQL Server 2005 Enterprise with 24GB of RAM. The /PAE switch is enabled. Can SQL now use the 24GB or does AWE need to be enabled? >>> More
HTTP responses curl and wget different results

as seen on Super User - Search for 'Super User'
To check HTTP response header for a set of urls I send with curl the following request headers foreach ( $urls as $url ) { // Setup headers - I used the same headers from Firefox version 2.0.0.6 $header[ ] = "Accept: text/xml,application/xml,application/xhtml+xml,"; $header[ ] = "text/html;q=0… >>> More