memory

  • To enable AWE and configure Lock Pages do we have to restart server or SQL service.

    any views.

    Regards
    Durai Nagarajan

  • AWE no. Locked pages, requires a service restart. If the /PAE switch is not in boot.ini already, that requires a reboot.

    32-bit only, on 64 neither PAE nor AWE is relevant.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • It is a 32 bit system, thanks for your input gail.

    Regards
    Durai Nagarajan

  • GilaMonster (11/8/2012)


    AWE no. Locked pages, requires a service restart

    Hi Gail,

    But MS specify in Books online that

    To make AWE available to an instance of SQL Server, use sp_configure to set the awe enabled option to 1, and then restart SQL Server.

    http://technet.microsoft.com/en-us/library/ms190673%28v=sql.105%29.aspx

    -----------------------------------------------------------------------------
    संकेत कोकणे

Viewing 4 posts - 1 through 3 (of 3 total)

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