All Things Distributed

APRIL 27, 2011

The Amazon.com 2010 Shareholder Letter Focusses on Technology. In the 2010 Shareholder Letter Jeff Bezos writes about the unique technologies developed at Amazon.com over the years. To do so, weve leaned heavily on the core principles from the distributed systems and database research communities and invented from there.

Technology 151

Technology Technology AWS Storage 151

SQL Performance

MARCH 29, 2022

Simple parameterization has a number of quirks in this area, which can result in more parameterized plans being cached than expected, or finding different results compared with the unparameterized version. For the time being, let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14. Users AS U.

Cache 90

Cache Servers Database Testing 90

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. Poor performance has a compound effect on user expectations at an ecosystem level. Live by the link, die by the link.

Performance 124

Performance Network Cache Metrics 124

SQL Performance

MARCH 22, 2022

Both target performance and efficiency for workloads frequently submitting simple statements. This series doesn’t dwell too long on the basics but concentrates on less well-known aspects likely to trip up even the most experienced database professionals. The aim is to reduce compilations by increasing cached plan reuse.

Cache 61

Cache Servers Database Code 61

SQL Performance

JUNE 8, 2022

As in previous parts, code examples use the Stack Overflow 2010 database on SQL Server 2019 CU 16 with the following additional nonclustered index: CREATE INDEX [ IX dbo. This could be unsafe in case-sensitive databases. Let’s look at the plan cache: SELECT. Users Reputation ( DisplayName ) ] ON dbo.

Cache 54

Cache Servers Database Processing 54

SQL Performance

APRIL 18, 2022

Let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14, with database compatibility set to 150. It’s important to remember the plan must be cached. Requesting an estimated plan from SSMS does not cache the plan produced (since SQL Server 2012). Dynamic Management Objects.

Cache 58

Cache Servers Database Testing 58

SQL Performance

MAY 20, 2022

Each component is active at a different time during compilation and performs its own parameterization-related tasks using the information available at that time. As in previous parts, most code examples use the Stack Overflow 2010 database on SQL Server 2019 CU 16 with the following additional nonclustered index: CREATE INDEX [ IX dbo.

Cache 55

Cache Database Servers Testing 55