Post reply

AWE

  • September 28, 2010 at 12:23 am

    #100315

    Dear All,

    We have a Database Server, the environment is Microsoft® Windows Server® 2008 Enterprise without Hyper-V and SQL Server 2005 - Standard Edition with SP3.

    Detailed Spec is,

    OS Name : Microsoft® Windows Server® 2008 Enterprise without Hyper-V

    System Type : X86-based PC

    Installed Physical Memory (RAM) : 32.0 GB

    Total Physical Memory : 32.0 GB

    Total Virtual Memory : 79.9 GB

    Page File Space : 48.0 GB

    Available Free Disc Space : GB (in System Partition)

    SQL Server 2005 - Standard Edition - SP3 (AWE Enabled)

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

    Minimum server memory ( in MB ) : 10240

    Maximum server memory ( in MB ) : 30720

    Minimum memory per query (in KB) : 1024

    We are having multiple databases in the server and many of the databases are huge in size.

    We need to set the maximum memory in AWE for SQL Server to ensure the performance.

    Can someone please let me know, what is the maximum memory that I can set for my SQL Server in my environment?

    Thanks and Regards,

    Ravichandra.

  • September 28, 2010 at 2:37 am

    #1228198

    Dear All,

    Can someone advise on the below request? please

    Thanks and Regards,

    Ravichandra.

  • September 28, 2010 at 9:21 am

    #1228467

    On a dedicated SQL server box, I usually set the max memory to 80% of the Total Physical RAM available.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • September 29, 2010 at 1:39 am

    #1228793

    Thanks.

    May I know how we can add/enable the /PAE switch in Windows Server 2008? or is it already been added by default?

    Please advise.

    Thanks and Regards,

    Ravichandra.

  • September 29, 2010 at 3:17 am

    #1228829

    AFAIK PAE switch is not enabled by default. This option is also applicable to Windows 2008. Please refer this

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • September 30, 2010 at 6:10 am

    #1229541

    Dear Pradeep,

    Thanks,

    How can I check whether /PAE switch was already been added or not in Windows Server2008? if it's not, how I can add it in 2008?

    Regards,

    Ravichandra.

  • September 30, 2010 at 9:03 am

    #1229684

    To enable PAE, use the /PAE switch in the Boot.ini file. Here is more info on that

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • September 30, 2010 at 9:06 am

    #1229686

    Thanks Pradeep.

    But it's applicable before windows server 2008 but it's different in 2008.

    And also how I can confirm whether it's added already or not?

    Regards,

    Ravichandra.

  • September 30, 2010 at 9:41 am

    #1229707

    To enable PAE mode, you have to add PAE to the boot entry in the BCD file. Open an elevated command prompt. Type BCDEDIT /SET PAE ForceEnable

    Refer "More information" section in this link and this link

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • October 4, 2010 at 5:36 am

    #1230915

    Thanks Pradeep for your information.

    But my doubt is not clear since my question is just I want to confirm whether /PAE switch was already added or not in Windows Server 2008.

    We can confirm this by opening the Boot.ini file in 2000 and 2003, ; but how can I confirm in 2008?

    Regards,

    Ravichandra.

  • October 4, 2010 at 10:23 am

    #1231118

    bcdedit.exe /enum ALL lists the BCD information

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • October 5, 2010 at 1:07 am

    #1231481

    Thanks for the help Pradeep.

    Regards,

    Ravichandra.

Viewing 12 posts - 1 through 11 (of 11 total)

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