SQL Server Performance

Whats the best way to setup memory on a four-node cluster?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Sep 6, 2007.

  1. Anonymous New Member

    Though it is more to do with SQL Storage kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances since, for example, two of the four servers could go down. In the majority of cases, you’re better off configuring each instance to use most of the memory available on each node. Let’s say that each node has 32GB of RAM. Setting max server memory...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/09/06/1912.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1912" width="1" height="1">

Share This Page