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

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

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 127

Performance Network Metrics Cache 127

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

Brendan Gregg

FEBRUARY 28, 2023

References I've reproduced the references from my SREcon22 keynote below, so you can click on links: [Gregg 08] Brendan Gregg, “ZFS L2ARC,” [link] , Jul 2008 [Gregg 10] Brendan Gregg, “Visualizations for Performance Analysis (and More),” [link] , 2010 [Greenberg 11] Marc Greenberg, “DDR4: Double the speed, double the latency?

Performance 52

Performance Latency Cache Virtualization 52

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

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 75

Virtualization AWS Engineering Hardware 75

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

CSS Wizardry

MARCH 3, 2019

Tip: There are a number of directives that Clear-Site-Data will accept: "cookies" , "storage" , "executionContexts" , and "*" (which, naturally, means ‘all of the above’). a CDN), to always serve the freshest possible copy, and not to persist anything to storage. Examples and Recipes. headers we might employ. Live Train Timetable Page.

Cache 266

Cache Latency Strategy Servers 266