It appears I am to be corrected regarding memory usage in SQL Server Express 2012 and higher versions. Direct quote from Microsoft:

Quote
Starting with SQL Server 2012, these memory limits are enforced only for the database cache (buffer pool). The rest of the caches in the SQL Server memory manager can use much more memory than is specified by these edition limits. For example, a SQL Server 2012 Express edition can use only a maximum size of 1.4 GB for its database cache. Other caches (such as the procedure cache, the metadata cache, and so on) can consume memory up to the size specified by the "max server memory" configuration.

What this means is what while the database cache is still limited to 1.4G of memory, the rest of SQL Server is no longer limited. So things such as the connection pool and so forth, can use more memory thereby making the move to 64-bit a good idea.

Thank you, Indy, for forwarding me the link from the official Microsoft documentation.

JamesNT

James Summerlin
My personal site: http://www.dataintegrationsolutions.net
james@dataintegrationsolutions.net