Post reply

Capacity planning | New SQL Server 2008

  • August 21, 2012 at 4:39 am

    #280036

    Hi Team,

    I am planing to find the memory requirement for SQL Server 2008 64 bit box. THis is a new box.

    I have only these information:

    1.OS version and edition : win 2008 with Enterprise or STD

    2.SQL server 2008 either Enterprise or STD

    3.No.of instance 1

    4.OLTP env

    5. 60% read activity / 40% write activity

    7. No.of users 500 - 1000 / hour

    8. Concurrent users : 100-200

    "More Green More Oxygen !! Plant a tree today"

  • August 21, 2012 at 4:41 am

    #1528031

    No way to answer from that little information.

    http://www.sqlskills.com/blogs/jonathan/post/How-much-memory-does-my-SQL-Server-actually-need.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 21, 2012 at 5:54 am

    #1528068

    As Gail said, there's no good way to answer that question. But you can start by looking up the minimum required to run SQL Server and add on top of that. I also recommend looking at your current memory usages and adding that to the equation. That will at least give you a baseline of memory.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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