Post reply

Server Configuration/Upgrade Question

  • May 17, 2005 at 3:30 pm

    #86389

    Normally I would go and find all of this information but I am under the gun for some answers so all help is appreciated.

    We have a new server to replace an existing server.  The new server has 4 processors and 8 GB of RAM.  We are running SQL Server 2000 Standard Edition on our current server.  Unfortunately, we did not purchase a SQL 2K Enterprise Edition Server license for the new server and it looks like we will have to wait until next year to budget for this license.  This is really not a problem because we bought this system for growth and we can make it through this year without Enterprise Edition.

    My first question is, am I correct that SQL 2K Standard Edition will only use 2 GB of RAM?  If so, does that mean the other server processes get the extra memory?  Also, would I still need to set the /3GB or /PAE switch?  What about AWE?  Is this only useful for Enterprise Edition?

    Secondly, if I install Standard Edition now and want to upgrade to Enterprise Edition next year, is this a hard upgrade to do?  Would I need to uninstall the Standard Editon and install the Enterprise Edition or would I just be able to upgrade the Standard Edition?

    I apologize for asking questions that may be very easy but I need to get some information fast.

    Thanks for all your help!

    hawg

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

  • May 17, 2005 at 11:10 pm

    #559458

    what is the operating System

    Operating SystemEnterprise EditionStandard Edition
    Microsoft Windows 2000 DataCenter64GB2GB
    Windows 2000 Advanced Server8GB2GB
    Windows 2000 Server4GB2GB
    Microsoft Windows NT 4.0 Server, Enterprise Edition3GB2GB
    Microsoft Windows NT 4.0 Server2GB2GB

    This will help you to determine whether your 8GB memory will be any useful.

     

    Secondly you do not need /3GB or /PAE switch.

    Standard Edition supports

    Up to 4 Processors

    Up to 2 GB of Memory.

     

    I will advise do not buy Enterprise Edition 2000 next year instead use the budget for SQL 2005 it has many great features.

    Yes you will need to uninstall and reinstall SQL Server to upgrade from Standard Edition. Unless someone has done or know a way to do.

     

    Thanks

    Amit

     

    Kindest Regards,

    Amit Lohia

  • May 18, 2005 at 8:38 am

    #559600

    For now, you've ot 4GB or so not being used on the server. Maybe you want to set it up to do other tasks as well to use some resources.

    Amit has great info on memory usage and I'd really look at upgrading to 2005. I elieve the Standard edition could use all your 8GB, assuming its out then

Viewing 3 posts - 1 through 2 (of 2 total)

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