I need some advice. I'm 2 levels of subcontractor down from the vendor for a client. The vendor has upgraded the client server to a 2008 64-bit server, but hasn't upgraded the SQL Server instance to 64-bit - they are running 2005 32-bit Standard Edition. When I asked why they didn't upgrade the client to a 64-bit version of SQL Server I was told that the vendor didn't want to support 64-bit SQL Server (maybe they don't have one in house - I don't know).
The server currently has 8 GB RAM, but I'm sure they wouldn't mind slapping in more since the client just spent a bunch of money on the upgrade and memory is cheap. The box is pretty much dedicated to SQL Server.
My first question: Is there any reason not to upgrade the SQL Server to a 64-bit version?
Second question: What would be the best config options for SQL Server under these circumstances?
I've never experienced a 32-bit SQL Server on a 64-bit Operating System.