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

Cameron%20Taggart's gravatar image

Cameron Taggart
1076610
accept rate: 0%

Note that starting with v12, the Deployment Wizard does support 64-bit, too.

Cf. the docs.

(03 May '11, 03:37) Volker Barth

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.

permanent link

answered 19 Mar '10, 08:35

Martin's gravatar image

Martin
8.6k116151237
accept rate: 14%

I presume that "client installation" deals with DBENG#.exe aka Personal Server.

(19 Mar '10, 10:49) Reimer Pods
1

@Reimer - no client would be a "client-server" client, not a Personal Server. Back in the old days there was an actual dbclient.exe, today the odbc driver, ado provider, etc. all contain the client gear to connect directly. A client app could be on the same physical machine as the server or a different physical machine. The Personal Server/dbengX.exe will benefit from the 64-bit memory space in the same way that the Network Server/dbsrvX.exe will. A 32-bit could still connect to a 64-bit Personal Server on the same machine.

(19 Mar '10, 14:04) Rob Waywell

@Martin: I would be interested how many clients (i.e. applications) would take advantage of being 64 bit - not the typical ones, methinks... Apps, that import huge blobs into databases?

(19 Mar '10, 17:35) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×36
×26

question asked: 19 Mar '10, 04:33

question was seen: 1,333 times

last updated: 03 May '11, 03:37