Get Answers from Microsoft SQL Server Data up to 1.37x as Fast with AWS EC2 M6i Instances vs. AWS EC2 M5 Instances

SQL Server

  • Analyze data up to 1.33x as fast on small M6i instances with 3rd Gen Intel Xeon Scalable processors vs. M5 instances.

  • Analyze data up to 1.37x as fast on medium M6i instances with 3rd Gen Intel Xeon Scalable processors vs. M5 instances.

  • Analyze data up to 1.13x as fast on large M6i instances with 3rd Gen Intel Xeon Scalable processors vs. M5 instances.

author-image

By

Speed up Data Analysis with AWS M6i Instances Featuring 3rd Gen Intel® Xeon® Scalable Processors

The amount of data organizations collect continues to grow, but that data is only useful if they can analyze it to make recommendations to customers or glean other business trends and insights. For various database sizes, AWS M6i Instances enabled by 3rd Gen Intel® Xeon® Scalable processors provide better analytics performance Microsoft SQL Server databases than M5 instances with older processors.

Using a TPROC-H workload from the HammerDB benchmark to assess SQL Server database analysis speeds, testing shows that for small, medium, and large-sized databases AWS M6i instances featuring 3rd Gen Intel Xeon Scalable processors analyzed data up to 1.37x as fast as M5 instances.

Plus, this significant boost in performance comes at no additional cost, which makes M6i instances a cost-effective solution plus higher performance. By choosing AWS M6i instances that can make sense of data faster, your organization can more quickly gain important insights that further your business’s success.

Small Instances: Analyzing 10GB Databases with 8 vCPUs

As Figure 1 shows, 8-vCPU M6i instances enabled by 3rd Gen Intel Xeon Scalable processors outperformed 8-vCPU M5 instances, analyzing data up to 1.33x as fast.

Figure 1. Relative speed to complete Microsoft SQL Server database query streams for small instances (8 vCPU), normalized to the speed of the m5.2xlarge instance.

Medium Instances: Analyzing 30GB Databases with 16 vCPUs

AWS medium-sized instances with 3rd Gen Intel® Xeon® Scalable processors once again improved data analysis speeds. As Figure 2 shows, M6i instances with 3rd Gen Intel Xeon Scalable processors analyzed SQL Server data up to 1.37x as fast as M5 instances.

Figure 2. Relative speed to complete Microsoft SQL Server database query streams for medium instances (16 vCPU), normalized to the speed of the m5.4xlarge instance.

Large Instances: Analyzing 100GB Databases with 64 vCPUs

Large instances with 100GB databases and 64 vCPUs also saw similar performance improvements moving to new 3rd Gen Intel Xeon Scalable processors from older CPUs. As Figure 3 shows, M6i instances enabled by 3rd Gen Intel Xeon Scalable processors analyzed SQL Server data up to 1.13x as fast as M5 instances.

Figure 3. Relative speed to complete Microsoft SQL Server database query streams for large instances (64 vCPU), normalized to the speed of the m5.16xlarge instance.

Learn More

To begin running your Microsoft SQL Server analytics workloads on AWS M6i Instances with 3rd Gen Intel Xeon Scalable processors, visit http://thailand.intel.com/aws.

To learn more about the results and test configurations, visit http://facts.pt/RWuDLHo.