Post reply

Enabling 12GB on SS2005 Standard/Windows Server 2003 Ent.

  • February 11, 2009 at 9:56 am

    #942310

    thanks for the update, that's the kind of thing that can be very helpful to someone else who comes along later, in the same situation, and is looking for answers.

  • February 11, 2009 at 10:04 am

    #942316

    SQAPro (2/11/2009)

    thanks for the update, that's the kind of thing that can be very helpful to someone else who comes along later, in the same situation, and is looking for answers.

    I think anyone who has experience searching these forums would agree! The questions outweigh the answers..

  • February 11, 2009 at 11:20 am

    #942391

    tung (2/11/2009)

    So BOL is probably not quite accurate in saying:

    Support for AWE is available only in the Enterprise and Developer editions and only applies to 32-bit operating systems.

    Again, we are using SS2005 Standard Edition 32-bit on Windows Server 2003 Enterprise.

    i pointed this out before on another post. SQL 2005 std will address OS max RAM so logically if thats the case how could AWE not be available.

    Check the technet site at

    http://technet.microsoft.com/en-us/library/ms179301(SQL.90).aspx

    and you will find different info as below

    Support for AWE is available only in the SQL Server 2005 Enterprise, Standard, and Developer editions and only applies to 32-bit operating systems. SQL Server 2005 Analysis Services (SSAS) cannot take advantage of AWE mapped memory. If the available physical memory is less than the user mode virtual address space, AWE cannot be enabled.

    😎

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply