Home Forums SQL Server 2008 SQL Server 2008 Administration SQL Instance Memory Allocation RE: SQL Instance Memory Allocation

  • October 31, 2013 at 4:50 am

    #1662985

    According to Brent Ozar's blog (in the comments) it's 64GB per instance. But you should read his reply to that comment.

    http://www.brentozar.com/archive/2010/06/sql-server-r-standard-supports-less-memory/[/url]

    EDIT: You should also consider what will happen to the OS if you're using 2 instances that gobble up the rest of the server's RAM.

    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.