February 17, 2006 at 3:30 pm
Hi All,
did SqlServer 2000 support up to 4 GB Ram? or more 6GB Ram?
(we use Windows 2000 Adv. Server SP4 and windows 2003 Enterprise Edition SP1),
does anyone have try this before?
Thanks in advance,
Best Regards,
Andy J.
February 17, 2006 at 3:40 pm
4GB I know it does. I haven't gone farther myself.
February 17, 2006 at 3:47 pm
This table shows the maximum amount of physical memory, or RAM, that the database engine in each SQL Server 2000 edition can support.
Operating System | Enterprise Edition | Standard Edition | Personal Edition | Developer Edition | Desktop Engine | SQL Server CE | Enterprise Evaluation Edition |
|---|---|---|---|---|---|---|---|
| Windows 2000 DataCenter | 64 GB | 2 GB | 2 GB | 64 GB | 2 GB | N/A | 64 GB |
| Windows 2000 Advanced Server | 8 GB | 2 GB | 2 GB | 8 GB | 2 GB | N/A | 8 GB |
| Windows 2000 Server | 4 GB | 2 GB | 2 GB | 4 GB | 2 GB | N/A | 4 GB |
| Windows 2000 Professional | N/A | N/A | 2 GB | 2 GB | 2 GB | N/A | 2 GB |
| Windows NT 4.0 Server, Enterprise Edition | 3 GB | 2 GB | 2 GB | 3 GB | 2 GB | N/A | 3 GB |
| Windows NT 4.0 Server | 2 GB | 2 GB | 2 GB | 2 GB | 2 GB | N/A | 2 GB |
| Windows NT 4.0 Workstation | N/A | N/A | 2 GB | 2 GB | 2 GB | N/A | 2 GB |
-Krishnan
February 17, 2006 at 7:06 pm
If you're on 32-bit processors though, you'll be looking at /PAE and so forth, I think.
February 19, 2006 at 6:13 pm
• Q274750 HOW TO: Configure Memory for More Than 2 GB in SQL Server, <http://support.microsoft.com/support/kb/articles/q274/7/50.asp>
• Q283037 Large Memory Support Is Available in Windows 2000, <http://support.microsoft.com/support/kb/articles/q283/0/37.asp>
• Q291988 A Description of the 4 GB RAM Tuning Feature and PAE Switch, <http://support.microsoft.com/support/kb/articles/q291/9/88.asp>
• Q292934 Windows 2000 Datacenter Server Does Not Locate Memory Over 16 GB, http://support.microsoft.com/support/kb/articles/q292/9/34.asp
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply