Speed Microsoft SQL Server Database Analysis by up to 1.49x with Microsoft Azure Dds_v4 VMs Featuring 2nd Gen Intel® Xeon® Scalable Processors

Microsoft SQL Server

  • Analyze data up to 1.49x as fast on medium instances.

  • Analyze data up to 1.35x as fast on large instances.

  • Boost analysis speeds across query streams.

author-image

By

Cut Analysis Times for Microsoft SQL Server Databases with Microsoft Azure Dds_v4 VMs Featuring 2nd Gen Intel Xeon Scalable Processors

Analysis Times for Microsoft SQL Server Databases with Microsoft Azure Dds_v4 VMs Featuring 2nd Gen Intel Xeon Scalable Processors

Successful organizations analyze the data they acquire and use it to make key changes to their business to improve sales and customer experience. Making sense of large amounts of data and turning its lessons into action takes time. The Microsoft Azure VM type you choose determines how fast you can glean those vital insights.

To cut data analysis times for Microsoft SQL Server databases, select a new Microsoft Azure Dds_v4 VM featuring powerful 2nd Gen Intel Xeon Scalable processors.

In Microsoft SQL Server online analytical processing (OLAP) tests comparing Microsoft Azure VMs, new Dds_v4 VMs featuring 2nd Gen Intel Xeon Scalable processors outperformed older Ds_v3 VMs enabled by Intel Xeon E5 v4 processors. A medium VM (with 16 vCPUs) analyzed data streams up to 1.49x as fast, and a large VM (with 64 vCPUs) analyzed data streams up to 1.35x as fast as similarly configured older Ds_v3 VMs.

At multiple combinations of query stream counts, database sizes, and VM sizes, choosing a new Dds_v4 VM featuring 2nd Gen Intel Xeon Scalable processors can empower you to analyze data faster, which can shorten the time it takes your organization to make critical business decisions.

Faster Data Analysis on Medium VMs

You already know the many benefits that running databases in the cloud offers— but have you considered the relative ease of moving to updated technology?

Running OLAP workloads on older hardware in the cloud can hold your business back from making timely decisions that affect your bottom line. Selecting VMs that run on newer processors can help your business speed up data analysis so you can be armed with the latest data insights to make the best informed decisions.

Tests comparing performance of medium VMs with 16 vCPUs show that Microsoft Azure Dds_v4 VMs featuring 2nd Gen Intel Xeon Scalable processors analyzed Microsoft SQL Server databases up to 1.49x as fast as Ds_v3 VMs running on older processors.

Figure 1. Relative speed to complete multiple query streams from a TPC-H-like HammerDB workload running against Microsoft SQL Server databases on medium-sized VMs.

This means that organizations looking to quickly gain insights from data can meet that goal by selecting Microsoft Azure Dds_v4 VMs featuring updated 2nd Gen Intel® Xeon® Scalable processors.

Faster Data Analysis on Large VMs

Because your organization is constantly collecting data, analysis of that data runs repeatedly. This means that over time, your organization could save days of analysis time by choosing VMs enabled by 2nd Gen Intel Xeon Scalable processors. In testing with larger VMs, new Dds_v4 VMs offered similar speed improvements to medium-VM testing over older Ds_v3 VMs. Using the HammerDB TPC-H-like workload to analyze large VMs showed that updated Microsoft Azure Dds_v4 VMs featuring 2nd Gen Intel Xeon Scalable processors completed data analysis up to 1.35x as quickly across multiple query stream counts as the Ds_v3 VMs did.

Figure 2. Relative speed to complete multiple query streams from a TPC-H-like HammerDB workload running against Microsoft SQL Server databases on large-sized VMs.

Analyzing Microsoft SQL Server databases on Microsoft Azure Dds_v4 VMs can speed up data analysis times compared to Ds_v3 VMs, so your organization isn’t stuck waiting to make critical business decisions.

Learn More

To begin your Microsoft SQL Server database deployments on Microsoft Azure Dds_v4 VMs featuring 2nd Gen Intel Xeon Scalable processors, visit http://intel.com/microsoftazure.

For more test details, visit http://facts.pt/IMBAPC9.