System IO Benchmarks
HammerDB Database Testing
HammerDB works with many different database suites including Oracle, MS SQL, and MySQL. I opted to use MS SQL, and I had to install Microsoft SQL 2016 to utilize all cores and threads of the CPU. All these tests were done on Server 2012 R2 with all updates. The program allows you to build a database; in this case, I built one with 507 warehouses and created 57 virtual users (one per core, the first virtual user controls the rest).
The point of the benchmark is to hammer the system CPU, memory, and storage. Building the test schema took about 3 hours, the 507 warehouses total to about 30GB of data. You cannot see it in the screenshot since this was taken shortly after starting the benchmark, but memory utilization peaks to around 30GB. It is hard to find the right combination of virtual users and warehouses to produce a constant transaction count, as it is common for the transaction counter to dip and then spike up (not ideal), which it isn't doing.
The system was able to process about 12,586,848 transactions per minute steadily until each virtual user executed 5 million transactions; each transaction is a random SQL query to try and produce real results. Databases are used in everything from your local dentist's office server to Facebook's mega warehouses.
The TYAN S7076 uses a server grade Intel i350 Gbit NIC. I used varying packet sizes from 1K to 64K and ran a looped test with IXIA.
Results were quite good, with performance not dipping until reaching much smaller packet sizes. However, if you are looking to support many clients, I would look to grab a 10Gbit NIC in the form of a mezzanine card for the OCP slot provided. TYAN even offers a list of compatible modules in their manual.
There are no voltage or frequency controls other than manual power state control in the BIOS. Therefore, you cannot overclock the CPU. There are however profiles; "Power", "Balanced Power", "Balanced Performance", and "Performance". You can either have the system balance to save power, or balance to increase performance.
I took power and temperature measurements of the system and CPUs to see what the difference between the "Power" and "Performance" settings provided. There is a difference, and it could be quite large considering servers run 24/7.
PRICING: You can find products similar to this one for sale below.
United States: Find other tech and computer products like this over at Amazon's website.
United Kingdom: Find other tech and computer products like this over at Amazon UK's website.
Canada: Find other tech and computer products like this over at Amazon Canada's website.
- We at TweakTown openly invite the companies who provide us with review samples / who are mentioned or discussed to express their opinion of our content. If any company representative wishes to respond, we will publish the response here.
Latest News Posts
- El Camino: A Breaking Bad Movie announced, drops October 11 on Netflix
- The best destruction physics in a game EVER, also features ray tracing
- NASA investigating first SPACE CRIME, as astronaut is naughty on ISS
- GTA 5 yanked from NVIDIA's GeForce Now streaming service
- The Clone Wars season 7 coming February 2020 on Disney+
- Lian Li TU150 Mini-ITX Chassis Review
- SteelSeries Arctis 9X Wireless Headset Review
- Seagate Gears 5TB Game Drive Review
- TRENDnet USB-C 2.5Gbe Network Adapter Review
- Mushkin Pilot-E NVMe M.2 SSD Review
- Snooker 19, the first official snooker game in a generation, is out now on Nintendo Switch
- Ultimate Fishing Simulator VR will debut in August
- Leyou Technologies Announces 2019 Interim Results
- Thermaltake A700 Aluminum Tempered Glass Edition Full Tower Chassis Now Available Simplicity Creates Its Own Path
- 2019 Thermaltake CaseMOD Invitational Season 2 Brings Twelve Top Modders Worldwide Together for the New Creation of the Core P5 V2 Chassis Battle for the Best