The Morning Paper

JANUARY 23, 2020

Today we’ll be digging into the analysis of an incident that took place at Etsy on December 4th, 2014. In fields such as software operations, it can be too easy to assume that the success of business-critical systems are owed solely to the speed, algorithmic prowess, and preventative design of automation. The last word.

Internet 53

Internet Internet Cache Engineering 53

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

SQL Performance

JUNE 21, 2019

For SQL Server 2008R – 2014, you could lower this threshold using trace flag 2371. While hardware such as intelligent SANs, Solid State Disk, and other advancements have helped speed things up, wasted space in index can translate to wasted space in the buffer pool as well as wasting more I/O. That can take a long time on larger tables.

Servers 49

Servers Azure Hardware Database 49

SQL Performance

JULY 16, 2019

This situation was so bad that Microsoft offered a 25% discount on the cost of SQL Server processor core licenses for SQL Server 2012 and SQL Server 2014, if you ran on qualifying AMD Opteron processors with six or more cores. They will also have up to 256MB of L3 cache per processor.

Servers 46

Servers Hardware Architecture Retail 46

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). Total elapsed time is 933ms with 6,673ms of CPU time with a warm cache. The clock keeps running at the same rate even during sleep.

Servers 95

Servers Tuning Architecture Processing 95

SQL Server According to Bob

DECEMBER 31, 2018

Several years ago, I created a XEProfiler based loosely on the SSMS implementation, built as a 64-bit application to avoid the 32-bit memory limitations and using parallel activities to speed up the processing. The XEProfiler Sample. Creates an empty DataGrid control. Makes a pass over the files to obtain the Event Locators.

Efficiency 40

Efficiency Code Servers Cache 40

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 ). Circa 2014, I was working with a big Japanese automotive brand in Australia. However, it is important to note that JAMstack can serve both static as well as dynamic content.

Systems 63

Systems Cache Website Network 63