Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Maximum Capacity Expand / Collapse
Author
Message
Posted Thursday, July 3, 2008 7:39 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, June 26, 2014 6:11 AM
Points: 1,330, Visits: 815
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.
Post #528049
Posted Thursday, July 3, 2008 7:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 26, 2014 3:23 PM
Points: 2,116, Visits: 6,439
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.


Apologies Jim, but the URL I mentioned was the top hit (actually just one of two) when I searched for "Workgroup RAM" in SQL BOL. I should have read the page more carefully before posting.

However, the link given with the answer is also a bit ambiguous, since in the 'Comments' column of the table it says "Memory limited to maximum supported by operating system".

I'll shut up now. ;)


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #528073
Posted Thursday, July 3, 2008 8:09 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 1:33 PM
Points: 457, Visits: 476
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!


Ron K.

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
Post #528090
Posted Thursday, July 3, 2008 8:14 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 11:02 AM
Points: 20,734, Visits: 32,497
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.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #528100
Posted Thursday, July 3, 2008 8:42 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 2:35 AM
Points: 2,716, Visits: 2,471
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!



Ron, you're missing the point that the BOL page that states this is the hardware requirements for installation, NOT a page that states how much RAM is supported by Workgroup. If you read up the thread you will see what I mean....

I agree it is confusing, and why MS would specify a maximum amount of RAM for installation is still a mystery.....


I suppose it's like a car manufacturer saying that their vehicle could withstand a speed of 200mph without falling apart, but then saying the top speed is 130mph - the two maximums have no relation :)



Kev
Post #528127
Posted Thursday, July 3, 2008 8:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 7:12 AM
Points: 1,049, Visits: 3,009
Agreed. There is no conflict between the BOL references. One states the maximum memory requirement for installing (and running) SQL Server Workgroup Edition, and the other statest the maximum memory SQL Server Workgroup Edition is actually capable of putting to good use once it's been installed and is up and running.

Yes, it's a subtle difference, but a perfectly reasonable one. Just look at the converse - if you installed SQL Server Workgroup Edition on a box with 512Mb RAM, then removed 256Mb and upped the page file by 256Mb, SS2k5 won't fail to run; it'll just run like a dog. Running requirements and installation requirements are two separate things.


Semper in excretia, sumus solum profundum variat
Post #528128
Posted Friday, July 4, 2008 12:54 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 12, 2012 5:46 AM
Points: 1,109, Visits: 279
Another reference more,

in this URL: http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx

in the chapter:
"Upgrading MSDE to different editions of SQL Server 2005"

Clearly shows the limit of 3GB for the Workgroup Edition.
Post #528519
Posted Monday, May 25, 2009 11:56 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 9:08 AM
Points: 1,511, Visits: 81
in msdn says maximum ram is : Maximun OS supported. not 3GB

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
Post #723042
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse