SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. This processor has a base clock speed of 2.0GHz, with an all-core boost speed of 2.55GHz, and a max boost clock speed of 3.0GHz. The L3 cache size is 64MB. Azure Lsv2 Details.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

Brendan Gregg

NOVEMBER 28, 2017

Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. In this configuration, the AMI and boot is paravirt (PV), the kernel is making hypercalls instead of privileged instructions, and the system is using paravirt network and storage drivers. I'd expect between 0.1% The AMI and boot are now HVM.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. This machine has four i7 CPUs (hyperthreaded to 8) with a base speed of 2.4GHz. Not everyone will be able to move to column store storage quickly, and it won't always be the right solution anyway. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

Abhishek Tiwari

NOVEMBER 3, 2018

They often get blindsided by vendor’s pitch and end-up making decision based on some fancy demos (see my post from 2014 on Adobe AEM ). Alternatively, you can upload output directory to cloud object/blob storage such as Amazon S3 or Azure Blob Storage and serve your site from there.

Systems 63

Systems Cache Website Network 63

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. Recall that single-core performance most directly translates into speed on the web. mid-priced Androids were slightly faster than 2014's iPhone 6. The Moto G4 , for example. How bad is it?

Performance 124

Performance Network Cache Metrics 124

Brendan Gregg

SEPTEMBER 5, 2017

Both Xen and KVM have had many performance and security improvements, and workloads can now be tuned to run at almost bare metal speeds (say, a 3% loss or less). Appliance manufacturers hire kernel engineers to develop custom features, including storage appliances. Outside of EC2, many other providers are deploying on KVM.

Virtualization 76

Virtualization AWS Engineering Hardware 76

SQL Server According to Bob

DECEMBER 31, 2018

Using SQL Server Management Studio (SSMS) and storing the events in a table requires reading the events, streaming to table storage followed by an order by event sequence query. Large traces can encounter the 32-bit SSMS memory limitations. The XEProfiler Sample. Creates an empty DataGrid control. Sorts the EventLocators.

Efficiency 40

Efficiency Code Servers Cache 40

All Things Distributed

DECEMBER 12, 2018

They started using AWS in 2014 after a decision to move away from outsourcing without having to build on-premises infrastructure, in an initiative to restart innovation in-house after a hiatus spanning several years. Telenor Connexion. Telenor Connexion is a part of one of the world's largest mobile telecommunications companies, Telenor.

AWS 124

AWS Cloud Games Serverless 124