Ron Kunce (7/3/2008)
jim.powers (7/3/2008)
This really isn't that hard to understand. The link posted with the question's answer is plainly obvious.http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
In the Workgroup column on the row for RAM, the limit is clearly stated at 3GB.
This has nothing to do with the OS installed on or the amount of installed memory in the system.
You are absolutely right, the link you provided clearly states the 3GB limit! However, as many of the others already complained about, the BOL page for SQL Server 2005 clearly states for :
"SQL Server 2005 Workgroup Edition
Pentium III-compatible processor or higher
Minimum: 600 MHz
Recommended: 1 GHz or higher
Minimum: 512 MB
Recommended: 1 GB or more
Maximum: Operating system maximum"
Clearly, a conflict in which documentation link to believe!
I'm having a hard time seeing the conflict. The question asked what was the maximum memory supported by SQL Servre Workgroup edition, that is 3GB. If you have a server with 1 GB RAM, and the system is slow, adding more ram will help. If you have a server with 6 GB ram, it won't use any more than 3 GB of the servers ram.
😎