RAM Shortage

It is common knowledge that SQL server is designed to make the best use of available physical memory. It will automatically cache data in the buffer pool and will use as much memory as the OS allows it to use. Advatronix's choice of the Xeon E3 comes with a serious disadvantage. Intel marketing decided that for product differentiation reasons, the Xeon E3 is limited to 8GB DIMMs and two DIMMs per channel (2 DPC). As a result any Xeon E3 system is limited to 32GB. That is serious limitation, even for a server in mid size or small business. But is 32GB "good enough"?

We tested the Cirrus 1200 with 16GB and 32GB. To determine if our workload could benefit from more than 32GB, we used the Supermicro server. Using the Microsoft Storage spaces functionality to create an SSD cached storage tier, we installed 64GB to see how much of a difference it makes. The buffer pool allocates more memory as we make more connections. We test up to 1024 connections requesting at 100 ms. Our transactional load can use more memory, as SQL server is using up to 42GB of RAM when we tested.

SQL Server 2012 OLTP: influence of RAM

Interestingly, there is very little performance difference between the software (Storage spaces) and the hardware based solutions (LSI, Cirrus 1200/Adaptec).

The average tower server with 64GB will deliver slightly better top performance (3-7.5%) than the Cirrus 1200, which is limited to 32GB. That is of course only important if you want the best database performance that is possible in this low end server market. The good news for the Cirrus 1200 is that SQL server is able to perform well with 16GB (75% of the 64GB performance), so you can probably reach about 80 to 90% performance if you need to run a file server alongside your database server.

Low latency database transactions test Top Performance
Comments Locked

39 Comments

View All Comments

  • JohanAnandtech - Sunday, June 8, 2014 - link

    The last point is where you make a reasoning error. Most enterprises just do not want to build their own fileserver, otherwise there would be not NAS market.
  • sciencegey - Monday, June 9, 2014 - link

    I was using the last point as an example of what a SOHO could do, which this storage server is targeted at.
  • tential - Saturday, June 7, 2014 - link

    Why couldn't they just sell the case by itself.....

    I don't need a 4500 system, I need a decent case like that.
  • Aikouka - Monday, June 9, 2014 - link

    Yeah, I was hoping this was actually just a server case review. =(
  • AdvatronixSystems - Saturday, September 27, 2014 - link

    We do sell the case by itself! :)

    Please contact sales@advatronix.com if you're interested.
  • watersb - Sunday, June 8, 2014 - link

    Thanks for reviewing this. Very interested in storage servers. But at these price points, I'm still in "build-your-own" territory.
  • YouInspireMe - Sunday, June 8, 2014 - link

    I have truly enjoy reading and have learned so much observing the high level exchange of knowledge here on this site I wonder if you could offer a little insight to a less knowledgeable fan of this sight. Other than it being headless and having lower power consumption what are the advantages/differences between a standard server and dedicated PC with sharing on a local network.
  • JohanAnandtech - Monday, June 9, 2014 - link

    Thanks. Another advantage is the build-in BMC which allows you to do remote management (remote power on, remote console). The rest is rather obvious: very little time is needed to replace PSU and the disks. I would definitely like the latter in my desktop :-).
  • CalaverasGrande - Monday, June 9, 2014 - link

    this looks like a server from the 90's except with a powder coat finish! So it must be good?
  • RoboKaren - Wednesday, June 11, 2014 - link

    Why not look at the BackBlaze StoragePod 4.0 derived commercial product, the Storinator: http://www.45drives.com/products/

    If I had $5k to spend on storage, I'd give it a serious look.

Log in

Don't have an account? Sign up now