Post reply

Help determining MAX Memory settings

  • August 30, 2012 at 11:27 am

    #261008

    I have 2 existing SQL server instances on an active/passive cluster. I've been tasked with determining the appropriate max memory setting for each. The server has 16gb of memory on each node and my plan is to leave 2gb for the OS. I know what the current usage is but I'm wondering if there is a good way to figure out what the max I should leave for each? One is using a significantly larger amount of memory right now but this is just a snapshot in time.

    Does anyone have any suggestions? Is 2gb enough for the OS given it's a cluster?

    Thanks

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

  • August 30, 2012 at 11:33 am

    #1532042

    Chapter 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    What you also need to consider is what's going to happen when one fails over? Do you set max memory so that both instances could fit on the one node? Or do you set so that each one uses the node's full resources and accept that when there's a failover there will be memory pressure and reduced performance?

    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 30, 2012 at 12:02 pm

    #1532050

    I'll read that chapter this afternoon. The cluster is active/passive and both nodes are identical. So I can just set the instances for the one node and when the fail over everything should be fine.

    Thanks for the help.

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

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

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