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 Wednesday, July 2, 2008 11:32 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Thursday, July 3, 2008 2:29 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Thursday, July 3, 2008 3:06 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:03 AM
Points: 2,467, Visits: 6,438
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?


--------------------------------------------------------------------------
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 #527856
Posted Thursday, July 3, 2008 4:05 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing 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
Posted Thursday, July 3, 2008 4:28 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:45 AM
Points: 2,716, Visits: 2,457
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
Posted Thursday, July 3, 2008 4:38 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:45 AM
Points: 2,716, Visits: 2,457
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
Posted Thursday, July 3, 2008 5:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:03 AM
Points: 2,467, Visits: 6,438
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?


--------------------------------------------------------------------------
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 #527916
Posted Thursday, July 3, 2008 5:19 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:45 AM
Points: 2,716, Visits: 2,457
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
Posted Thursday, July 3, 2008 5:35 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:03 AM
Points: 2,467, Visits: 6,438
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


--------------------------------------------------------------------------
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 #527934
Posted Thursday, July 3, 2008 6:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:43 AM
Points: 2,580, Visits: 3,832
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 »

Add to briefcase 12»»

Permissions Expand / Collapse