We are attempting to export about 30 GB database via 1C accounting application. The SQL server is at 20% CPU utilization and appears to use all available ram - 2GB out of 4. I've read about the /3GB flag, but we would like to stuff more memory into server and have SQL server use more. What do I have to do? Will just upgrading Windows 2003 Server from Standard Edition to Enterprise Edition help?
I think the best way is to go for x64 architecture, if you want to get all the benefits from added RAM. The things would work much more natively in that way. We have several highloaded instances of 1C (16GB of RAM on SQL and application servers), SQL2005 x64 works well on Windows Server 2003 R2 x64 edition. As for application server (if you need it), we use Terminal Services on Windows Server 2003 x64 and also 2008 x64 and everything goes OK. The version of 1C is 8.0, I'm not sure if the things are all right if you mean 7.7, though.