• Jeff Moden (11/28/2015)


    When you start talking about tera-bytes for an instance, I'd start thinking about a lot more memory than 64GB per node and I wouldn't think about splitting it up much. Either you're in business, or you're not. Skimping on hardware doesn't make sense especially when it comes to RAM.

    I have to agree with Jeff 1000% here. If you're using SQL 2014 SE, then the max SQL Server will use is 128 GB. When you compare the price between 64 GB and 128 GB, it's almost inconsequential when you consider the cost of your SQL licensing. If you're using SQL 2014 EE, then it can use as much as the server and OS can support. When you look at the high price tag of EE, you want to feed it as much power as you can to utilize your investment as much as possible.

    SQL Server loves memory. Skimping out on memory is handicapping your environment right out of the gate.