Are people noticing major differences in performance with SQL 64 Bit? I'm not seeing any difference.

SQL 2012 Express Limitations:

  • Limited to lesser of 1 Socket or 4 cores
  • 1 GB maximum memory per instance
  • 10GB max database size

There shouldn't be any noticeable difference between 64 bit and 32 bit SQL EXPRESS. You're still limited to 1GB per instance. While SQL has other components that can push it over 4GB. The database instance is limited to 1 GB. Also, it shouldn't be restricted to 1 core but 4 cores. It's one reason why people with i7 Processors have better performance than Xeon users due to the higher clockspeed of the 4 cores. SQL full is multi-threaded, but SQL Express benefits from higher clocked cores.

I will be checking this soon, but it could be possible that in the new AC version it has been restricted to 1 core instead of the normal 4 cores or it may be seeing quad core processors and 4 separate processors and applying the single socket limitation.

Sandeep Luthra | LTMedical.net
2023 Practice Systems now available