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

Memory configuration Expand / Collapse
Author
Message
Posted Wednesday, April 2, 2014 10:34 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 4:38 AM
Points: 335, Visits: 1,141
Hi,
What is the max memory support for SQL server 2000(32 bit)

when i came across technet i got this information

Operating System Enterprise Edition Standard Edition Personal Edition Developer Edition "Desktop Engine
(MSDE 2000)"
Windows 2000 DataCenter 64 GB 2 GB 2 GB 64 GB 2 GB

SQL Server CE Enterprise Evaluation Edition

N/A 64 GB

http://technet.microsoft.com/en-us/library/aa933149(v=sql.80).aspx

If i use operating system as Windows NT 4.0 Server RAM is limited to 2 GB ?

so if my operating system is Windows 2000 DataCenter (32) bit can i use 64 GB of RAM?

Any suggestions on this.
Post #1557807
Posted Thursday, April 3, 2014 1:02 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:54 AM
Points: 42,767, Visits: 35,867
The documentation is correct (unsurprising)


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1557841
Posted Thursday, April 3, 2014 3:58 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 4:38 AM
Points: 335, Visits: 1,141
Thanks Gail for replaying in this SQL 2000 forum.
So if i am using Windows 2000 DataCenter as 32 bit OS , can it take 64 GB of RAM.
Post #1557887
Posted Thursday, April 3, 2014 10:08 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:54 AM
Points: 42,767, Visits: 35,867
If that's what the documentation says, then that's what it can take.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1558076
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse