Monday, May 11, 2009

awe enabled Option - MsSql 2005

In Windows Server 2003, you able change the Address Windowing Extensions (AWE) API to provide access to physical memory in excess of the limits set on configured virtual memory. The specific amount of memory you can use depends on hardware configuration and operating system support.

  • Windows Server 2003, Standard Edition supports physical memory up to 4 gigabytes (GB).
  • Windows Server 2003, Enterprise Edition supports physical memory up to 32 GB.
  • Windows Server 2003, Datacenter Edition supports physical memory up to 64 GB.

Extra Note

  • You are not running Express or Workgroup version of SQL Server. Please check here for further details about limitations in different versions of SQL Server.
  • you have enabled awe enabled option and set max server memory to the maximum memory you can allocate to SQL Server. This is applicatiable for 32 but versions of OS and not required in 64 bit version of Windows servers. Please check here for further details and how to configure the memoryfor SQL Server


James_Iha said...

Limitations of AWE

1.Using SQL Server 2005 (32-bit) with AWE has some limitations. The additional memory addressability is available only to the relational database engine, not to other engines such as Analysis Services. The benefits are limited to those operations that can directly access database pages stored in the expanded buffer cache — operations such as building indexes on large tables, or simple queries from cache. AWE does not enhance other memory-intensive operations using the stored procedure cache or log cache.
Although its benefits are significant, the potential performance enhancements from AWE do not apply to the following operations or components:
Analysis Services
Procedure Cache for compiled plans
ODBC parameter caching
Sort area
Index creation, including full-text indexing
Hash memory
Per-connection memory
Lock memory

2.There is a potential threat that the data is corrupted when PAE is enabled on a Windows Server 2003-based computer"[]...When you run Microsoft SQL Server on a Microsoft Windows Server 2003-based computer, data that is saved to the SQL Server database may be corrupted. This problem may occur if you use the Intel Physical Addressing Extension (PAE) specification to support more than 4 gigabytes (GB) of installed memory in your computer".

Though the problem can be fixed by installing the hotfix provided, yet it still need time to study other consequences.

Anonymous said...

The world owes you nothing. It was here first. Being happy doesn't mean that everything is perfect Runescape Gold, Empty what's full. Scratch where it itches. Don't go around saying the world owes you a living RS Gold, It means that you've decided to look beyond Runescape Money the imperfections. Do not pray for tasks equal to your powers.

It takes strength to be truthful when a lie would be more convenient D3 Gold, it takes strength to be polite to someone when that person has been rude to you Buy D3 Gold, it takes strength to persist in the face of obstacles, when it would be much easier to simply give up Cheap D3 Gold.