Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
Please can you clarify which version of SQL server (2000 or 2005 you specify both in the question title)? Which edition of SQL server? 32 bit or 64 bit? –  SuperCoolMoss Jul 24 '09 at 15:59
    
If I am not mistaken, it is 2000, 32 bit. –  Konrads Jul 26 '09 at 7:34
    
Thanks Konrads, and what's the edition of SQL server? (Enterprise / Standard etc.). –  SuperCoolMoss Jul 26 '09 at 8:49

3 Answers 3

up vote 2 down vote accepted

Per the table right at the bottom of this page, SQL 2000 standard edition won't use more than 2GB of ram, but depending on what server OS you are running, the Enterprise Edition of SQL Server 2000 can use up to 64 GB of RAM.

It's all about pricing and market segmentation, I'm afraid.

share|improve this answer
    
I think this is the ultimate cause. I wonder if there is a quick way to upgrade 2000 Std to EE for migration. –  Konrads Jul 26 '09 at 7:36

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.

share|improve this answer

If you're running 32bit SQL with one instance, than no. 3GB is max.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.