HomeWinBuzzer NewsMicrosoft's SQL Server 2016 Breaks World Performance Record

Microsoft’s SQL Server 2016 Breaks World Performance Record

The SQL server has beaten the TPC-H 10 TB benchmark, making it the fastest in-memory database on the market. It was achieved using Lenovo System x3850 X6.

-

On 11 July posted a TPC-H 10TB benchmark result using Windows SQL Server 2016 and Windows Server 2016 that broke world records. has now commented on the breakthrough, describing the server's performance as “unparalleled.”

The used four of Intel's Xeon E7-8890 v4 processors, 6TB of memory and eight SanDisk ioMemory SX350 6.4TB PCIe flash adapters. This allowed a score of 1,106,832.6 QphH @ 10,000 GB, with a price of $0.79 USD/ QphH :10,000GB.

The benchmark beats the previous non-clustered performance score by 5.7%, which used the same , OS, database and memory size. Price per performance also beats records at 26% lower than the competitor.

Microsoft's Reaction

The SQL Server Team had a lot to say on the TechNet blog about the record and what it means for their SQL Server:

“These results, in addition to recent benchmarks by software and hardware partners, as well as key applications, show that SQL Server 2016 is the fastest in-memory database on the planet for your applications.”

They mention Lenovo's TPC-H 30TB world record, which also used SQL Server 2016 and proves that the technology is consistently the fastest in the market.

Going into more detail about the other benchmarks, they write:

“SQL Server 2016 owns the top TPC-E performance benchmarks4 for transaction processing, the top TPC-H performance benchmarks for data warehousing, and the top performance benchmarks with leading business applications. PROS Holdings uses SQL Server 2016's superior performance and built-in R Service to deliver advanced analytics more than 100x faster than before, resulting in higher profits for their customers. KPMG, a leader in audit, tax, and advisory solution, posted 2.5x faster execution time with ten times the table compression with their solution using SQL Server 2016.”

The statistics reinforce the benefits of upgrading to SQL Server 2016, with Queries running up to 34x faster according to Microsoft's internal testing. Their claim of the best performance on the market is now looking to be entirely true.

Further information about SQL Server 2016 is found on the official website, and it can be tested for free through the developer edition.

Ryan Maskell
Ryan Maskellhttps://ryanmaskell.co.uk
Ryan has had a passion for gaming and technology since early childhood. Fusing the skills from his Creative Writing and Publishing degree with profound technical knowledge, he enjoys covering news about Microsoft. As an avid writer, he is also working on his debut novel.

Recent News