Announcement

Collapse
No announcement yet.

Accessing memory for 32bit SQL on 64bit Windows

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Accessing memory for 32bit SQL on 64bit Windows

    We have installed SQL 2000 (32bit) onto a windows Server 2003 x64 server with 8 GB of RAM. With 32bit OS we had to set the /3GB and /PAE switches in the boot.ini in order to access more than 3 GB of memory.

    Since this is using a 64bit OS I assume we don’t need the /3GB switch but since SQL is 32bit should we use AWE or PAE switches? The server is dedicated for SQL server so we would like it to use all the memory it can and we’re not yet ready to migrate to SQL 2008 64bit.

    Thanks.

  • #2
    Re: Accessing memory for 32bit SQL on 64bit Windows

    We're looking to deply this in production either this week or next. Anyone has experience with this?

    Thanks.

    Comment


    • #3
      Re: Accessing memory for 32bit SQL on 64bit Windows

      The /3GB, /PAE etc switches are all for a 32bit OS so are no use for an x64 OS. The WOW (I think) should sort out giving SQL what it needs although it is still limited to 4GB as far as I'm aware.
      cheers
      Andy

      Please read this before you post:


      Quis custodiet ipsos custodes?

      Comment


      • #4
        Re: Accessing memory for 32bit SQL on 64bit Windows

        I'm pretty sure you'll need to use AWE for SQL as it's 32 bit and won't natively be able to use anything above 4GB of RAM without AWE.

        Comment

        Working...
        X