CODEWITHSUNDEEP
sqlmemory
Peter van Kekem
Peter van Kekem

Reputation: 1447

Can a 32bit process access 64GB memory?

I've a strange situation: A server, containing 64GB of memory, runs a SQL server process (64 bit) which consumes 32 GB of memory. There is about 17 GB memory available.

MS Dynamics Nav is running on top of SQL

Besides the 64bit SQL process, there is another SQL process and a NAS, both running 32 bits.

Every now and then, an error message is logged in the eventviewer, saying

There is not enough memory to execute this function.

If you work in a single-user installation, you can try reducing the value of the 'cache' program property. You can find information about how to optimize the operating system in the documentation for yo

Now I'm wondering what the problem is, since there is still 17 GB memory available. Is it possible that a 32-bit process cannot allocate memory in the last segment (60 to 64 GB)?

Upvotes: 0

Views: 253

Answers (1)

lehn0058
lehn0058

Reputation: 20257

32 bit processes are limited to about 4 GB of memory usage. The x64 architecture should allow a 32bit process to run in any of the available memory space, but your 32bit process will still be limited by it's maximum addressible space (~4GB).

Upvotes: 3

Related Questions