I thought I saw someone mention that SQL2KEE can access a full 4GB on x64.
Can someone verify this? Here are 2 links that appear to support this.
http://msdn.microsoft.com/library/d...consumption.asp
http://msdn.microsoft.com/library/d..._management.aspRunning 32-bit version of sqlserver does you no good. See this document for
details.
http://download.microsoft.com/downl...tAdvantages.doc
-oj
"Mike Kruchten" <mrk@.fsisolutions.com> wrote in message
news:uyO2zO1eFHA.3836@.tk2msftngp13.phx.gbl...
>I thought I saw someone mention that SQL2KEE can access a full 4GB on x64.
>Can someone verify this? Here are 2 links that appear to support this.
> http://msdn.microsoft.com/library/d...consumption.asp
> http://msdn.microsoft.com/library/d..._management.asp
>|||Well, being from March 2004 this document doesn't say anything about running
32-bit SQL2000 on x64 W2k3. The following quote from one of the links I
provided leads me to believe that SQL2000EE running in this environment will
be able to use a full 4GB of virtual memory.
---
On the x64 processor, each 32-bit application receives 4 GB virtual address
space in the WOW64 environment, if the application has the
IMAGE_FILE_LARGE_ADDRESS_AWARE flag set in the image header. If this flag is
not set, the 32-bit application receives 2 GB virtual address space.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u7XB3Q6eFHA.3932@.TK2MSFTNGP12.phx.gbl...
> Running 32-bit version of sqlserver does you no good. See this document
> for details.
> http://download.microsoft.com/downl...tAdvantages.doc
>
> --
> -oj
>
>|||You're right. SQL2K (32bit) SP4 allows you to run it in WOW64. Though, I am
not sure if you can actually use up 4Gb. If you have windbg, you can try to
look it up *live* - don't have a x64 here else I would check it out for
sure.
-oj
"Mike Kruchten" <mrk@.fsisolutions.com> wrote in message
news:ukcPvG%23eFHA.1456@.TK2MSFTNGP15.phx.gbl...
> Well, being from March 2004 this document doesn't say anything about
> running 32-bit SQL2000 on x64 W2k3. The following quote from one of the
> links I provided leads me to believe that SQL2000EE running in this
> environment will be able to use a full 4GB of virtual memory.
>
> ---
> On the x64 processor, each 32-bit application receives 4 GB virtual
> address space in the WOW64 environment, if the application has the
> IMAGE_FILE_LARGE_ADDRESS_AWARE flag set in the image header. If this flag
> is not set, the 32-bit application receives 2 GB virtual address space.
>
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u7XB3Q6eFHA.3932@.TK2MSFTNGP12.phx.gbl...
>|||Is there any official work on this yet?
Daren
"Mike Kruchten" <mrk@.fsisolutions.com> wrote in message
news:uyO2zO1eFHA.3836@.tk2msftngp13.phx.gbl...
> I thought I saw someone mention that SQL2KEE can access a full 4GB on x64.
> Can someone verify this? Here are 2 links that appear to support this.
>
http://msdn.microsoft.com/library/d...consumption.asp
>
http://msdn.microsoft.com/library/d...ent.asp
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment