Post reply

adding more ram

  • February 12, 2007 at 7:22 am

    #69514

    Hi,

    we use windows2003std and SQL2000 Enterprise Edition.

    We want add more ram cause the database is growing a lot. ( now 3 gb ram, we want 12 gb )

    I guess i must update to Windows 2003 Entprise Edition or i wrong ??

    Greets Rene

  • February 12, 2007 at 7:26 am

    #689152

    std is limited to 4gb unless you go 64bit R2 which supports 32gb ram

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 12, 2007 at 8:33 am

    #689217

    i will upgrade to w2k3 enterprise who can handle 32 gig also.

  • February 12, 2007 at 9:37 am

    #689233

    actually with R2 Enterprise it's now 64Gb

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 13, 2007 at 8:47 am

    #689483

    ... and once you get the OS lined up don't forget:

    /PAE boot startup configuration option

    and

    "Lock Pages in Memory" in the Local Security Policy settings

    as well as letting SQL Server know you want to use the additional RAM.

    PeteK


    PeteK
    I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.

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

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