<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by jprakasam
»
Maximum Capacity
18 posts, Page 2 of 2
««
1
2
Maximum Capacity
Rate Topic
Display Mode
Topic Options
Author
Message
jim.powers
jim.powers
Posted Thursday, July 03, 2008 7:39 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, February 04, 2013 10:00 AM
Points: 1,329,
Visits: 803
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
Jan Van der Eecken
Jan Van der Eecken
Posted Thursday, July 03, 2008 7:57 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 7:07 AM
Points: 2,265,
Visits: 5,948
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. ;)
--------------------------------------------------------------------------
The function of good software is to make the complex appear to be simple. (Grady Booch)
Post #528073
Ron Kunce
Ron Kunce
Posted Thursday, July 03, 2008 8:09 AM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 11:56 AM
Points: 454,
Visits: 418
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
Lynn Pettis
Lynn Pettis
Posted Thursday, July 03, 2008 8:14 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 2:28 PM
Points: 21,611,
Visits: 27,442
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
kevriley
kevriley
Posted Thursday, July 03, 2008 8:42 AM
SSCrazy
Group: General Forum Members
Last Login: Monday, May 13, 2013 12:01 PM
Points: 2,677,
Visits: 2,273
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
majorbloodnock
majorbloodnock
Posted Thursday, July 03, 2008 8:42 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 9:44 AM
Points: 1,043,
Visits: 2,943
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
j nuñez
j nuñez
Posted Friday, July 04, 2008 12:54 AM
Ten 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
jmatayoshi
jmatayoshi
Posted Monday, May 25, 2009 11:56 AM
SSCommitted
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 »
18 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
