<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 1 of 2
1
2
»»
Maximum Capacity
Rate Topic
Display Mode
Topic Options
Author
Message
jprakasam
jprakasam
Posted Wednesday, July 02, 2008 11:32 PM
Old Hand
Group: General Forum Members
Last Login: Wednesday, April 20, 2011 9:30 AM
Points: 351,
Visits: 39
Comments posted to this topic are about the item
Maximum Capacity
Post #527763
bilalhaider86
bilalhaider86
Posted Thursday, July 03, 2008 2:29 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, October 21, 2008 10:55 PM
Points: 23,
Visits: 39
I think it should be acccording to OS.
OS should bring the limit on RAM as it is controller of all the resources of a System.
Simply
hehe:
Post #527842
Jan Van der Eecken
Jan Van der Eecken
Posted Thursday, July 03, 2008 3:06 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 3:08 AM
Points: 2,307,
Visits: 6,087
From BOL:
SQL Server 2005 Workgroup Edition
[Processor Type] Pentium III-compatible processor or higher
[Processor Speed] Minimum: 600 MHz
Recommended: 1 GHz or higher
[Memory] Minimum: 512 MB
Recommended: 1 GB or more
Maximum: Operating system maximum
Now who is right? BOL? The author of the question? Both?
--------------------------------------------------------------------------
The function of good software is to make the complex appear to be simple. (Grady Booch)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #527856
Bill Mell
Bill Mell
Posted Thursday, July 03, 2008 4:05 AM
SSChasing Mays
Group: General Forum Members
Last Login: Saturday, March 19, 2011 12:37 PM
Points: 603,
Visits: 63
According to BOL it is the Operating System Maximum
Post #527888
kevriley
kevriley
Posted Thursday, July 03, 2008 4:28 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 2:29 AM
Points: 2,677,
Visits: 2,277
BOL is stating the
requirements
for install
Whereas the MS link is stating the features and limits
I would be more likely to believe the 3Gb limit
Kev
Post #527897
kevriley
kevriley
Posted Thursday, July 03, 2008 4:38 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 2:29 AM
Points: 2,677,
Visits: 2,277
in fact if you check BOL at this page
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/95e5e902-66f9-4ef0-a7c6-61f42d81362e.htm
(put that into the address bar of BOL)
it states again that Workgroup Edn supports a max of 3Gb.
Kev
Post #527898
Jan Van der Eecken
Jan Van der Eecken
Posted Thursday, July 03, 2008 5:03 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 3:08 AM
Points: 2,307,
Visits: 6,087
But if you look at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/09bcf20b-0a40-4131-907f-61479d5e4d8.htm
in BOL it reads "Operating system maximum".
To me 3GB looks more like a limit imposed by Windows 32 bit architecture on an x86 machine. Has anyone tried installing SQL 2K5 Workgroup on a 64 bit machine with a 64 bit OS and attempted to push it past 3GB? The same BOL article mentioned above says it is supported on Windows Server 2003 x64 Standard/Enterprise/Datacentre (all SP1) and Vista x64 Business/Enterprise/Ultimate through WOW64. Unfortunately I neither have the time nor the resources to try it myself. Any volunteers?
--------------------------------------------------------------------------
The function of good software is to make the complex appear to be simple. (Grady Booch)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #527916
kevriley
kevriley
Posted Thursday, July 03, 2008 5:19 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 2:29 AM
Points: 2,677,
Visits: 2,277
that url didn't work for me did you mean
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/09bcf20b-0a40-4131-907f-b61479d5e4d8.htm
that's the h/w reqs for installing and running SQL, NOT the supported features - a subtle difference, but a difference.
I don't know why they would state a MAX memory for installing, but I'll do some digging......
Post #527926
Jan Van der Eecken
Jan Van der Eecken
Posted Thursday, July 03, 2008 5:35 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 3:08 AM
Points: 2,307,
Visits: 6,087
You are right about the URL Kev. Don't ask me how I managed to drop that "b" when copying and pasting.
And yes, you are right when you say that the page showing the HW/SW requirements for installing SQL 2K5. Indeed a subtle difference. The only reason I can think of that they state a maximum amount of RAM would be that there is a bug in the installer that causes it to crash when the machine has more than 3GB available to user processes :P
--------------------------------------------------------------------------
The function of good software is to make the complex appear to be simple. (Grady Booch)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #527934
OCTom
OCTom
Posted Thursday, July 03, 2008 6:49 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 10:06 AM
Points: 2,029,
Visits: 2,867
Here's another link that shows the 3GB limit albeit from the perspective of SBS2003 R2 Premium Edition which includes SQL Server 2005 Workgroup Edition.
http://www.microsoft.com/WindowsServer2003/sbs/evaluation/faq/sql2005.mspx
Post #528004
« Prev Topic
|
Next Topic »
18 posts, Page 1 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.
