Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Maximum Capacity


Maximum Capacity

Author
Message
jim.powers
jim.powers
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1343 Visits: 839
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.
Jan Van der Eecken
Jan Van der Eecken
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2214 Visits: 6490
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. Wink

--------------------------------------------------------------------------
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)
Ron Kunce
Ron Kunce
SSC-Addicted
SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)

Group: General Forum Members
Points: 470 Visits: 496
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
Lynn Pettis
Lynn Pettis
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24217 Visits: 37978
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.

Cool

Cool
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)
kevriley
kevriley
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2751 Visits: 2606
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 Smile



Kev
majorbloodnock
majorbloodnock
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1113 Visits: 3062
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
j nuñez
j nuñez
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1109 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.
jmatayoshi
jmatayoshi
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1511 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search