32 bit vs. 64 bit

I'm running SQL Workgroup edition (32 bit) on a 64 bit OS. Would I see a performance gain from upgrading to SQL Standard 64 bit? Hardware is DL385 2 proc AMD 2.8 Ghz with 6 GB RAM. Has anyone made this comparison and how much gain did you see?

I am not sure the performance that can be obtained. But one thing is clear that upgrading 32-bit to 64-bit is not supported directly. If you really want to perform such an upgrading, you can do as follows.

Approach one.

1. Uninstall 32-bit and save database

2. Install 64-bit and attach the saved database

Approach two.

1. Install 64-bit side by side with 32-bit, which is supported.

2. Export 32-bit data to 64-bit.

3. Uninstall 32-bit.

Anyway, please backup your database before doing any major operation on your database.