Are there any advantages of doing a 64-bit deployment of SQL Anyhwere for Windows rather than a 32-bit deployment on a 64-bit Windows OS like Windows 7 64-bit or Windows Server 2008 64-bit? Since the deployment wizard only support 32-bit Windows Installer Packages, doing a 64-bit deployment would be much more difficult.
asked 19 Mar '10, 04:33
You can use more memory for the database cache, which will lead to performance improvements. This is advantageous even if your client is still only a 32 Bit application. Anyway this advantage is only relevant, if your databases are larger (or will grow) than the max database cache size for 32 Bit (which is limited nativ to 1.8 GB (AWE could use more, but has other limitations, Glenn has given a good explanation here)).
So for the server OS my recommendation would be yes, for the client installation it depends on the used database sizes.
answered 19 Mar '10, 08:35