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.
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.
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.