How Intel Xeon E5 Processors Supercharge Database Performance

Intel-2016-08-24-SSG Xeon E5 MarkLogic blog_Twitter (1) (1)

By Mike Pearce, Ph.D. HPC Developer Evangelist

Databases form the bedrock of many enterprise operations, but unfortunately, many of them are not built to handle the powerful operations that a contemporary business environment requires. The MarkLogic* Enterprise NoSQL database platform, when combined with the Intel® Xeon® E5-2600 v4 processor family, and the Intel® Solid State Drive Data Center P3700 results in a powerful solution to wrangle the rising tide of data, ultimately resulting in less hardware and more headroom for the future.

New and Emergent Demands for Databases

No matter which industry you look at, data volumes are growing. The ubiquity of real-time searches, database queries, and applications that scale to meet Internet demands are all increasing the scale of data exponentially.

This scaling often translates into a painful reality for many businesses as they try to work through data sets that are growing explosively. NoSQL databases are powerful tools for dealing specifically with this growth, using a more flexible data model as compared to more traditional approaches.

Why Processor Performance Matters

The MarkLogic NoSQL database platform is designed to load, tokenize, and index massive data volumes at high speed. Powering that design, however, is another matter entirely, and that’s where the Xeon E5 family comes in.

For four generations of processors, the Xeon E5 has powered database operations with progressive increases in cache sizes and core counts. The Xeon E5 v4 is no exception. Wherever data goes, you’re sure to find a Xeon processor not far behind. And the growing sizes of data requiring management mean you’ll need a more powerful processor to keep up.

How To Boost Performance

Staying on the cutting edge is important for your bottom line, which is why Intel regularly releases new generations of the Xeon processor, with marked improvements between each generation. The Xeon E5 v2 family is still common in many data centers, but a recent benchmark study by Intel and MarkLogic v4 showed query performance improvements of 2.2X times over the v2 generation. Similarly upgrading from the Xeon E5 v3 to the latest v4 resulted in a 1.3X performance boost.

Click the image to view the full paper and more details.
Click the image to view the full paper and more details.

Rounding out these performance gains is the Intel Solid State Drive Data Center Family (Intel® SSD DC) for PCI Express* (PCIe*). You can’t have a great data center without a storage solution that offers fantastic throughput and unparalleled latency. Intel SSDs offer 4 terabytes of data capacity per PCIe 3.0 slot, supporting data transfer rates of 2.8 gigabytes per second, dramatically reducing the time for data ingestion.

What does this all mean for your business? In short, you can use fewer servers to handle heavier workloads with plenty of headroom to spare. This will help handle the unexpected, which is nearly always a given in the world of database inquiry.

Read and download the full paper here. If you’re interested in finding out more about software solutions running on Xeon E5, check out our page. Find more information on Xeon processors and continue the conversation on Twitter, at @mikeapmap and @IntelITCenter.