Post reply

memory setup

  • June 14, 2010 at 10:04 am

    #157015

    I am doing some future planning for an in place upgrade of sql2000 standard 32 bit. Will be upgrading to sql2005 standard 32 bit running on a windows server 2003 32 bit environment. Questions is... we will have 12 gigs of ram on the server and I want to have the most ram i can get available to the SQL server. How do I accomplish that? can someone please outline the steps needed?

    thanks! 🙂

  • June 14, 2010 at 12:53 pm

    #1180053

    There are more folks on this forum who know more about memory config than I do, but here's how I would approach it assuming that the server is hosting only one instance of SQL Server and it is a dedicated server. Please also reference - http://msdn.microsoft.com/en-us/library/ms187499.aspx

    1) Set Windows permission - Locked Pages in Memory

    2) In SQL Server, set 'awe enabled' parameter using sp_configure

    3) REALLY important - set your min to 2GB and max memory parameter to 10 GB leaving 2 GB or so for the OS.

    Not that you asked, but I would research if an in-place install is really the best approach for your upgrade. I personally wouldn't recommend it.

    Cindy

  • June 14, 2010 at 11:57 pm

    #1180202

    CavyPrincess (6/14/2010)

    Not that you asked, but I would research if an in-place install is really the best approach for your upgrade. I personally wouldn't recommend it

    i didnt get this . can you explain it ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • June 15, 2010 at 7:01 am

    #1180371

    Just an off-handed comment. I'm personally not a fan of in-place upgrades. If feasible, I prefer to install the new instance, then migrate from the old instance to the new one. It makes the backout plan much easier, but I realize that there are more implementation steps involved and there may not be the hardware to support this approach. Thus the suggestion to research the different approaches.

    Truly unsolicited and not relevent to the question asked. I guess I should either "stick to topic" or explain myself better 🙂

    Cindy

  • June 15, 2010 at 7:12 am

    #1180380

    Thanks CavyPrincess. I have been reading conflicting reports on if we can even enable AWE setting on sql 2005 standard edition... Not sure if its a Enterprise ed only property.

  • June 15, 2010 at 7:24 am

    #1180396

    I can't say from experience, as I use Enterprise Edition, but the link indicates it should work with Standard as well.

    Cindy

Viewing 6 posts - 1 through 5 (of 5 total)

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