AWE & boot.ini

  • SQL Server 2000 Enterprise Edition on Windows 2000 Advanced Server -> has 8GB or RAM.

    What should the boot.ini look like for SQL Server engine to access this 8GB ?

  • where within the boot.ini does this go ?

    can you give an example ?

  • should be at the end of the line that specifies which instance of w2k you are launching.

    Steve Jones

    steve@dkranch.net

  • In SQL BOL look for AWE using this syntax:

    "Using AWE Memory on Windows 2000"

    There are other settings in SQL that need to be set and BOL has good coverage from the query provided above.

    cabby

    Always Learn!

  • [boot loader]

    timeout=30

    default=multi(0)disk(0)rdisk(0)partition(1)\WINNT

    [operating systems]

    multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced Server" /fastdetect /3GB


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

Viewing 6 posts - 1 through 5 (of 5 total)

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