Low latency database transactions test

Before we can start comparing the Cirrus 1200 to an alternative configuration, we must find out how we should configure our system. Indeed there are two cache levels, the RAM cache of the controller and the SSD cache, and both can be set to cache reading and/or writing. That gives us eight different configurations, though not all of them make sense of course.

OLTP performance: write / read cache

There is a quirk in the Adaptec software. We first enabled Maxcache on a single SSD. Adaptec asked us whether we are sure (as SSDs can fail too) and when we answered "yes", all the software (BIOS and Maxview) reported proudly that SSD caching was enabled. It turned out that this was not the case at all. Only when we set the SSD to RAID-1 was Maxcache (SSD caching) properly enabled.

The results are somewhat surprising: once the Maxcache works properly, it seems that the RAID controller cache just adds latency. The RAID controller does help when the SSD does not accelerate writing, but with Maxcache active on the SSDs the RAID controller caching slows things down a bit.

The next question that we asked ourselves is whether it still matters to have lots of spinning disks behind the SSD cache. After all, the SSD cache seems to be doing all the hard work. So we replaced the eight Seagate 4TB drives in RAID-10 with a two disk system using RAID-1.

OLTP performance: number of disks

 

The performance gain of using eight spindles instead of two is pretty small, but it is still measureable. We show a 22% increase in the total number of transactions. In most small businesses this performance increase will not be enough to convince people to use this many disks on for a database. The RAID-1 setup is probably better as more disks can then be used for serving files and documents. This way, the storage capacity of the file server can be a lot bigger, which is a huge advantage. In most enterprises, file server capacity will be a much higher priority than a few procentagaes of extra database performance.

Benchmark Configuration RAM Shortage
Comments Locked

39 Comments

View All Comments

  • Kevin G - Friday, June 6, 2014 - link

    It really comes down to scale. A single system, regardless if it is a 4U server or a gaming rig can be run in a home environment and not have to worry too much about cooling. Sure, putting them in a closet with the door closet will cause them to bake but that'd be true of any high power piece of electronics.

    For a single server, a CRAC is overkill. When dealing with a room with hundreds of racks, each full of servers, a CRAC is necessary to deal with the heat output. CRAC's are also designed with datacenter RAS methodology. They're highly modular to ease service, typically fit into standard rack row and have monitoring capabilities. Multiple CRAC's can also load balance the cooling needs of a room or act has a 'hot spare' in case another unit fails. These are features you don't find in home air conditioning units.

    There is also another thing to factor in comparing a gaming rig with server: size. Common servers are either 1U or 2U in height which means they'll use small high RPM fans internally. This means they're loud and there are a lot of them. Cooling for rack servers is done in one direction: front to back. A gaming rig tends to have plenty of room. Larger, lower RPM fans *can* move more air than several smaller 80 mm fans. In addition, the typical gamer case has more area to draw into it as well as for exhaust. In otherwords, a gaming case is less restrict in terms of airflow for cooling.
  • sciencegey - Saturday, June 7, 2014 - link

    It isn't to do with power draw, it's the fact that your PC isn't running 24/7 with loads of HDDs (which create a lot of heat) and the fact that they will be running at around about 60% load constantly. Also, CRAC is just a fancy way of saying air conditioning.
  • Ratman6161 - Friday, June 6, 2014 - link

    Ummmmm. If your business relies on this data then it shouldn't be "under your desk".

    And don't forget your UPS and your offsite backups either. Another issue I see is that a company of a size that might be looking at something like this probably doesn't have any IT support in house to manage those backups and disaster recovery procedures. Unfortunately that's just the sort of situation where I find businesses doing this sort of thing. An amateur sets something up "under his desk" but when it fails they are screwed. Or when that person leaves the company they are screwed.

    So there are probably certain niches where this sort of system could be useful but if a company doesn't either have IT staff or at least a support contract to manage things, it's very likely they would be better off in the cloud - if only for disaster recovery purposes.
  • Gunbuster - Friday, June 6, 2014 - link

    The Dell T620 has a chassis option for 32 2.5" Hard Drives
  • valinor89 - Friday, June 6, 2014 - link

    "Moreover, while renting a few Terrabytes in the cloud has become relatively affordable..."
    Terrabytes is meant as a joke or a typo? It sounds cool anyway.
  • rpg1966 - Friday, June 6, 2014 - link

    Terrabytes!

    https://d2kxqxnk1i5o9a.cloudfront.net/uploads/pict...
  • thunderbird32 - Friday, June 6, 2014 - link

    Fujitsu is a weird company. I've never been able to find a reseller that carries their x86 servers or workstations. One wonders how much business they do in that category in the US.
  • JohanAnandtech - Tuesday, June 10, 2014 - link

    Thanks for sharing. Each time I went to Cebit, the people at Fujitsu had little interest talking to me, as I was international press. It is like the x86 line is their just to complete their product portfolio.
  • Drizzt321 - Friday, June 6, 2014 - link

    I would have liked to have seen an option to ditch the RAID cards and move to simple HBA cards to allow OS management of the arrays. Would also probably decrease the cost by a good bit.
  • sciencegey - Saturday, June 7, 2014 - link

    This thing seems kinda pointless because if you are a small business, you can get a cheap server rack and then get a storage server and even have places to put your network switch and VoIP box. This means you won't have to take up precious office space (you can mount server racks on walls) with this giant blue box. If you are really too cheap for a server rack-mount system, then you would probably just build your own file server, which is pretty easy (if you love Linux, make you own distro, use current distros like FreeNAS or shell out to get Windows Server. And if you are using Macs, then you just use a Time Machine/hackintosh as a Time Machine).

Log in

Don't have an account? Sign up now