All Things Distributed

OCTOBER 2, 2017

We were pushing the limits of what was a leading commercial database at the time and were unable to sustain the availability, scalability and performance needs that our growing Amazon business demanded. Performant – The service would need to be able to maintain consistent performance in the face of diverse customer workloads.

Internet 130

Internet Internet AWS Performance 130

SQL Performance

MARCH 22, 2022

Both target performance and efficiency for workloads frequently submitting simple statements. In this first part, after a quick introduction, I look at the effects of simple parameterization on the plan cache. The aim is to reduce compilations by increasing cached plan reuse. Simple Parameterization. sp_configure. EXECUTE sys.

Cache 61

Cache Servers Database Code 61

SQL Performance

MAY 16, 2019

Achieving minimal logging using INSERT.SELECT into an empty clustered index target is not quite as simple as described in the Data Performance Loading Guide. The Data Loading Performance Guide contains a high-level summary of the conditions required for minimal logging into clustered tables: This post is concerned with the top row only.

Cache 67

Cache Servers Testing Storage 67

SQL Performance

APRIL 18, 2022

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). Once the plan is cached, the StatementParameterizationType appears in the usual places, including via sys.dm_exec_query_plan. Performance Counters.

Cache 58

Cache Servers Database Testing 58

Tim Kadlec

JUNE 21, 2022

HTTP/3 work started in 2012 with Google working on QUIC, adopted by IETF in 2017, RFC’s published in June 2022. The browser stores alt-svc info in alt-svc cache. Testing the Performance of HTTP/3. Protocol performance is rarely low0hanging fruit. Here are my notes. What and Why? HTTP/3 builds on top of UDP, not TCP.

Network 64

Network Mobile Google Cache 64

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. Let’s look at the plan cache: SELECT. The parameter data types are still different, so separate plans are cached and no plan reuse occurs. usecounts , CP.

Cache 55

Cache Database Servers Testing 55

All Things Distributed

MAY 13, 2012

By Werner Vogels on 14 May 2012 12:01 AM. Query String based Caching: the ability to include query string parameters as part of the objects cache key. URL based configuration: the ability to configure cache behaviors based on URL path patterns. All Things Distributed. Dynamic Content Support in Amazon CloudFront.

Cache 118

Cache Latency AWS Website 118

All Things Distributed

NOVEMBER 17, 2012

By Werner Vogels on 17 November 2012 11:00 PM. The Andrew File System (AFS) was developed at CMU and was much more than just a distributed file systems and had a very interesting caching and volume replication architecture. Scale and performance in a distributed file system , John H. All Things Distributed. Comments ().

Systems 88

Systems Government Cache Scalability 88

SQL Performance

JUNE 21, 2019

What I find is very similar to backups: No DBCC CHECKDBs performed at all DBCC CHECKDBs being performed only on select databases DBCC CHECKDBs last performed months or years ago. SQL Server 2012 introduced a memory manager rewrite so that the maximum server memory value applies to all SQL Server memory allocations.

Servers 49

Servers Azure Hardware Database 49

SQL Performance

JULY 16, 2019

For many years, I explicitly advised people not to run their SQL Server workloads on AMD hardware because of the much lower single-threaded CPU performance and consequently higher SQL Server core license costs. This has led to a very noticeable reduction in generational performance increases since Broadwell-EP, as shown in Figure 1.

Servers 46

Servers Hardware Architecture Retail 46

SQL Server According to Bob

JUNE 3, 2016

. ‘It Just Runs Faster’ – Out of the box SQL Server 2016 DBCC provides you better performance, scale while shrinking your maintenance window(s.). The DBCC CheckDB demonstration loads a table and demonstrates the performance improvement. Ryan Stonecipher – Principle SQL Server Software Engineer. or newer release.

Hardware 40

Hardware Cache Servers Software Engineering 40

Smashing Magazine

JUNE 30, 2021

The Problem Of Unpredictable Performance. At the same time, we have a widening performance gap. In terms for performance, these phones have plateaued at the performance of a 2012 iPhone. Applications built for the Web are expected to run on devices that fall anywhere on this broad performance spectrum.

Games 145

Games Architecture Code C++ 145

SQL Server According to Bob

JUNE 3, 2016

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. With our focused investment in performance and scale, simply upgrading to SQL 2016 could bring 25% performance improvement. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Performance

AUGUST 23, 2019

In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join. There have been major improvements since the first appearance of the batch mode execution engine in SQL Server 2012. Background. Simple Bitmaps. Bitmap Choice.

Servers 75

Servers Engineering Efficiency Retail 75

Percona

JUNE 4, 2023

Critical features of MariaDB include robust security features like encryption at rest and in transit, user authentication, and role-based access control (RBAC), as well as high-performance query execution, advanced indexing techniques, and replication, clustering, and sharding, ensuring scalability and high availability. What is MySQL?

Open Source 52

Open Source Servers Storage Scalability 52

Smashing Magazine

APRIL 9, 2019

With these added libraries and subsequent plugins came added page weight, and before long we were starting to think seriously about front-end performance. They’d take the hit for the first site to use the file, but then it would sit in their local browser cache and downloads could be skipped for each subsequent site.

Website 57

Website Servers Code Best Practices 57

All Things Distributed

JANUARY 18, 2012

By Werner Vogels on 18 January 2012 07:00 AM. Amazon DynamoDB is a fully managed NoSQL database service that provides fast performance at any scale. Any downtime or performance degradation in these services has an immediate financial impact and their fault-tolerance and performance requirements for their data systems are very strict.

Scalability 167

Scalability Database Ecommerce Latency 167

Smashing Magazine

AUGUST 20, 2021

Ben and Mena Trott created MovableType because of a “Dissatisfacion with existing blog CMSes — performance, stability.” In 2006, Denis Defreyne tried to set up a Ruby-based blog platform and ran into performance problems — “Having a VPS with only 96 MB of RAM, any Ruby-based CMS ran extremely slowly.”

Ecommerce 139

Ecommerce Website Government Internet 139