Post reply

SQL Server 2000 RAM limitations on windows 2000 server

  • January 14, 2004 at 1:28 pm

    #358916

    Is SQL server 2000 really limited to 2GB RAM on a windows 2000 server

  • January 14, 2004 at 1:37 pm

    #490057

    Maximum Amount of Physical Memory Supported by the Editions of SQL Server 2000

    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 DataCenter64 GB2 GB2 GB64 GB2 GBN/A64 GB
    Windows 2000 Advanced Server8 GB2 GB2 GB8 GB2 GBN/A8 GB
    Windows 2000 Server4 GB2 GB2 GB4 GB2 GBN/A4 GB
    Windows 2000 ProfessionalN/AN/A2 GB2 GB2 GBN/A2 GB
    Windows NT 4.0 Server, Enterprise Edition3 GB2 GB2 GB3 GB2 GBN/A3 GB
    Windows NT 4.0 Server2 GB2 GB2 GB2 GB2 GBN/A2 GB
    Windows NT 4.0 WorkstationN/AN/A2 GB2 GB2 GBN/A2 GB

  • January 14, 2004 at 2:28 pm

    #490075

    Wasn't aware that you've already replied, Allen.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 14, 2004 at 2:34 pm

    #490079

    No problem, Frank. Any inputs are welcomed. That is how we learn.

  • January 15, 2004 at 7:19 am

    #490191

    Thanks for the info but how can I see which version of SQL Server I actually have?

  • January 15, 2004 at 7:20 am

    #490192

    select @@version

  • January 15, 2004 at 7:41 am

    #490197

    or

    SELECT SERVERPROPERTY ('productversion')

    SELECT SERVERPROPERTY ('productlevel')

    SELECT SERVERPROPERTY ('edition')

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 16, 2004 at 7:35 am

    #490425

    Actually, your table is wrong....SQL Enterprise on standard Windows 2000 should read 2 gig, not 4 gig.    See article http://support.microsoft.com/default.aspx?scid=kb;en-us;291988

    "When the /3GB switch is used with Windows 2000 Professional or with Windows 2000 Server, the kernel components are loaded into the memory space by using the 4 GB RAM Tuning feature in the same way as they load in Windows 2000 Advanced Server and in Windows 2000 Datacenter Server. This functionality lets device-driver developers test their drivers in this configuration without having to install Windows 2000 Advanced Server or Windows 2000 Datacenter Server. The user-mode memory space is still limited to 2 Gig."

     

    CSaalfeld@Harcourt.com

  • January 16, 2004 at 7:40 am

    #490427

    Let me go one step further....that entire line in your table (Windows 2000 Server) should read no higher than 2 gig all the way across....

     

    CSaalfeld

  • January 16, 2004 at 7:59 am

    #490428

    Hm,...I think I have seen exactly this table in BOL under Maximum Capacity Specification.

    And I have updated BOL

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 16, 2004 at 1:34 pm

    #490536

    But have you actually tried it?  According to the article  http://support.microsoft.com/default.aspx?scid=kb;en-us;291988

    the OS is still reserving 2 gig, leaving only 2 gig for SQL to see.

  • January 16, 2004 at 1:50 pm

    #490539

    The article specifically says...

    "The use of the /3GB switch from the Boot.ini file with Windows 2000 Professional or with Windows 2000 Server can give the appearance of a 3 GB range of user-mode memory. However, the memory from 0x80000000 through 0xBFFFFFFF is not usable. Because kernel-mode components are now limited to using from 0xC0000000 through 0xFFFFFFF memory range, developers can test kernel-mode components without having to install Windows 2000 Advanced Server, Windows 2000 Datacenter Server, or the Windows Server 2003 family of products. "

     

    and....

    "IMPORTANT: These configurations are not supported on Windows 2000 Professional and Windows 2000 Server. These configurations are only made available for testing purposes. Do not use these switches in a production environment unless you are using one of the products in the bulleted list at the top of this section."

    The article was last reviewed on 10/8/2003 .....newer than the newest BOL.

  • January 19, 2004 at 3:16 am

    #490622

    No, I haven't tried.

    I have no influence on the hardware. And our smart admins put 3 GB of RAM on a box with SQL 2K standard edition, and asked me why this doesn't work

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply