Philip,
SQL express allows utilization of 1 GB or RAM, regardless of how much your server has
Wow I didn't know that. That's horrible. And "SQL Server 2005 Express Edition Overview" says it "supports 1 CPU, 1 GB RAM, and a 4 GB database size.". So if you have 2 CPU's what does it do, use processor affinity to lock itself to one?
AC does not support anything other than SQL server 2005 express from what I understand, so once you've upgraded and there is an issue, the upgrade gets the blame from tech support, I speak from experience.
Wow what a crappy choice. Be stuck with an anemic buffer size or be on AC's bad side. I'm a rule follower so I'm not sure I could stomach using unsupported software. But yeah I was hoping to get at least 24GB RAM but what's the point. We don't run anything on the main machine besides AC and file sharing.
This could influence me to stick with a workstation instead of a server. AC seems like it's not ready for server hardware.
