Results 1 to 11 of 11
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: Memory Recommendations

    I have a client with a 90 GB database.
    Largest tables are 10-15 GB.
    They are running on SQL Server 2005 Standard, with 8 GB or RAM.

    That does not seem like enough RAM to me.

    What do you all think is a good rule of thumb for minimum RAM?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    Jun 2007
    Location
    Ohio, USA
    Posts
    142
    I think that would depend heavily on load, rather than DB size. Is this OLAP or OLTP, and how many users are we talking? 8GB is pretty good, as a standard, but also depends on disk config and processor. Can you provide more system specs?

    -D.
    David Maxwell
    Data Integrity? Yeah, I've heard of that...

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    64 bit, or 32 and you've got AWE enabled? /3 gb switch?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Got AWE enabled, and I think it is 64 bit.
    How does the 32/64 relate to memory requirements?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    It just seems that I heard somewhere that a good rule of thumb is to have enough memory to cover the largest table.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    64 vs 32 is a massive deal for memory. You don't need to enable AWE for 64 bit.

    I could try to cover it all but the below linky is superb. The short of it is, in 32 bit SQL Server cannot use more than 3 GB RAM (and only 2GB if the /3 GB switch is not enabled) for anything other than data cache. If AWE is enabled then it can use remaining available memory for data cache, however the OS needs to maintain pointers to these locations so you are limited by the amount of memory the OS can use (which is 1GB is the /3 GB switch is used).

    All this matters nowt if it is 64 bit so you really need to bottom that out.

    http://blogs.msdn.com/chadboyd/archi...awe-oh-my.aspx
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Oh yeah - I would also say this is the sort of thing to check counters before recommending adding memory. If SQL Server isn't bottlenecking on memory then adding memory ain't gonna help.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Thanks for nothing, poots!
    Last edited by blindman; 11-20-08 at 14:19.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  9. #9
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912

    Thumbs up

    Quote Originally Posted by blindman
    Thanks, poots!
    Bookmarked
    Testimonial:
    pootle flump
    ur codings are working excelent.

  10. #10
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by pootle flump
    Bookmarked
    Edited!
    .
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  11. #11
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    When it comes to memory, I stand by my original analysis (from the 1970s). Whatever you have is 80% of what you need.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •