Post reply

awe enable

  • February 20, 2008 at 9:38 am

    #179314

    Hi,

    i have enable the awe on the sqlserver and given min memory 1024MB,maximum memory 6124MB .after enabling the awe i have run dbcc memory status command in that i t showing awe allocated is 0.

    my machines has 8GB RAM.

    Any help highly appreciated...........

  • February 20, 2008 at 9:40 am

    #780276

    x32 only uses awe. you must have the /pae switch set in boot.ini. you must set awe option on, you must set max memory. min memory is ignored with awe, you take all memory in one hit up to defined max. you'll need lock pages in memory. have a look in the sql error log it should tell you what's missing.

    if you're using x64 awe doesn't do anything.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 20, 2008 at 1:29 pm

    #780379

    Please don't cross post. It wastes people's time.

    Replies to the following thread please - AWE Settings

    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

  • February 21, 2008 at 2:43 am

    #780549

    Hi,

    Everything is done........but when i run dbcc memory status & sp_configure it showing AWE allocated is zero.......

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

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