You will not see major Performance boost as HPSIM is still 32bit, however if you can install 64bit SQL Server and use it with HPSIM, you will see some boost up due to to faster SQL operations.
And regarding the memory problem, the HPSIM memory foot print cannot cross >1.55 or 1.7 GB on Windows systems regardless of 32bit or 64bit as there is JVM limitation.