SQL Performance

FEBRUARY 22, 2021

Recently one of our teams was investigating a log reader latency issue. We pay a lot of attention to latency here, along with any long-running transactions, because of downstream impact to technologies that use the log reader – like Availability Groups and transactional replication. dm_os_performance_counters.

Latency 57

Latency Servers Monitoring Systems 57

Brendan Gregg

JULY 4, 2021

## References I've reproduced the talk references 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? Ford, et al., “TCP

Performance 52

Performance Latency Hardware Storage 52

All Things Distributed

NOVEMBER 12, 2012

By Werner Vogels on 12 November 2012 05:00 AM. This new Asia Pacific (Sydney) Region has been highly requested by companies worldwide, and it provides low latency access to AWS services for those who target customers in Australia and New Zealand. introducing the Asia Pacific (Sydney) Region. Comments ().

Cloud 118

Cloud AWS Ecommerce Latency 118

All Things Distributed

NOVEMBER 13, 2018

In 2012, Amazon opened its first Italian office and its first Italian point of presence (PoP) based in Milan. We needed to serve our growing base of startup, government, and enterprise customers across many vertical industries, including automotive, financial services, media and entertainment, high technology, education, and energy.

AWS 167

AWS Energy Automotive Traffic 167

All Things Distributed

JUNE 21, 2017

DynamoDB has come a long way in the 5 years since we announced its availability in January 2012. These high-throughput, low-latency requirements need caching, not as a consideration, but as a best practice.

Speed 123

Speed Cache Latency AWS 123

All Things Distributed

MAY 13, 2012

By Werner Vogels on 14 May 2012 12:01 AM. With just one click you can enable content to be distributed to the customer with low latency and high-reliability. This is in addition to the existing optimizations of routing viewers to the edge location with lowest latency for that user, and also persistent connections with the clients.

Cache 118

Cache Latency AWS Website 118

Alex Russell

MARCH 6, 2021

The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively. If those specs sound eerily familiar, it's perhaps because they're identical to 2016's $200USD Moto G4 , all the way down to the 2011-vintage 28nm SoC process node used to fab the chip's anemic, 2012-vintage A53 cores. Tap for a larger version.

Performance 124

Performance Network Cache Metrics 124

All Things Distributed

FEBRUARY 22, 2012

By Werner Vogels on 22 February 2012 12:01 AM. They must deal with the increased latency and unreliability inherent in remote communication. Tasks can be long-running, may fail, may timeout and may complete with varying throughputs and latencies. All Things Distributed. Expanding the Cloud â?? The Amazon Simple Workflow Service.

Cloud 130

Cloud AWS Java Scalability 130

All Things Distributed

OCTOBER 2, 2017

With these goals in mind, In January, 2012 we launched Amazon DynamoDB , our cloud-based NoSQL database service designed from the ground up to support extreme scale, with the security, availability, performance and manageability needed to run mission-critical workloads. Manageable – The service would need to be easy to manage and operate.

Internet 130

Internet Internet AWS Performance 130

All Things Distributed

SEPTEMBER 25, 2017

This Region will consist of three Availability Zones at launch, and it will provide even lower latency to users across the Middle East. The Region will be in the heart of Gulf Cooperation Council (GCC) countries, and we're aiming to have it ready by early 2019. This news marks the 22nd AWS Region we have announced globally.

Cloud 154

Cloud Education Energy Government 154

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). The rapid acceleration in technology brought on a new discovery and paradigm.

Availability 40

Availability Servers Hardware Benchmarking 40

All Things Distributed

JANUARY 23, 2012

By Werner Vogels on 23 January 2012 12:01 AM. VM Import allows our customers to move virtual machine images from their datacenters to the Cloud and Amazon Direct Connect makes the network latencies and bandwidth between on-premises and AWS more predictable. All Things Distributed. Expanding the Cloud - The AWS Storage Gateway.

Storage 116

Storage AWS Virtualization Cloud 116

All Things Distributed

JANUARY 18, 2012

By Werner Vogels on 18 January 2012 07:00 AM. Amazon DynamoDB offers low, predictable latencies at any scale. This is not just predictability of median performance and latency, but also at the end of the distribution (the 99.9th percentile), so we could provide acceptable performance for virtually every customer. Comments ().

Scalability 167

Scalability Database Ecommerce Latency 167

All Things Distributed

NOVEMBER 8, 2012

By Werner Vogels on 08 November 2012 03:00 PM. For example, AWS customers use SQS for asynchronous communication pipelines, buffer queues for databases, asynchronous work queues, and moving latency out of highly responsive requests paths. All Things Distributed. Werner Vogels weblog on building scalable and robust distributed systems.

Efficiency 107

Efficiency Cloud Games Scalability 107

The Netflix TechBlog

DECEMBER 17, 2019

Passive instances across regions are also possible, though it is recommended to operate in the same region as the database host in order to keep the change capture latencies low. Production usage DBLog is the foundation of the MySQL and PostgreSQL Connectors at Netflix, which are used in Delta. References [1] Das, Shirshanka, et al. “

Database 197

Database Traffic Transportation Open Source 197

All Things Distributed

SEPTEMBER 25, 2012

By Werner Vogels on 25 September 2012 06:00 PM. Within a week the latency for end-users was cut in half and there were no longer performance fluctuations in their architecture. All Things Distributed. Werner Vogels weblog on building scalable and robust distributed systems. Expanding the Cloud â?? Provisioned IOPS for Amazon RDS.

Cloud 118

Cloud AWS Storage Database 118

The Netflix TechBlog

DECEMBER 17, 2019

Passive instances across regions are also possible, though it is recommended to operate in the same region as the database host in order to keep the change capture latencies low. Production usage DBLog is the foundation of the MySQL and PostgreSQL Connectors at Netflix, which are used in Delta. References [1] Das, Shirshanka, et al. “

Database 212

Database Traffic Transportation Open Source 212

All Things Distributed

DECEMBER 12, 2013

So when we launched in January 2012, we provided simple query functionality that used hash primary keys or composite primary keys (hash + range). Since then, we have been working on adding flexible querying. You saw the first iteration in April 2013 with the launch of Local Secondary Indexes (LSI).

Games 130

Games Scalability Database Retail 130

Alex Russell

JULY 14, 2021

From at least 2012, Apple has deigned to allow "competing browsers" in its App Store. In particular, folks will undoubtedly note that "alternative browsers" were available in the App Store much earlier, including a Chrome-branded app since at least 2012. Apple's right to worry about engine security.

Google 121

Google Mobile Engineering Internet 121

ScaleOut Software

MAY 15, 2014

Likewise, object access paths must be heavily multi-threaded and avoid lock contention to minimize access latency and maximize throughput. For example, the IMDG must be able to efficiently create millions of objects in each server to make use of its huge storage capacity.

Cache 40

Cache Servers Network Design 40

Smashing Magazine

AUGUST 20, 2021

In 2012, Dave Cole published a post on How we build CMS free websites. Platforms such as Snipcart , CommerceLayer , headless Shopify , and Stripe enable you to manage products in a friendly UI while taking advantage of the benefits of Jamstack: Amazon’s famous study reported that for every 100ms in latency, they lose 1% of sales.

Ecommerce 139

Ecommerce Website Government Internet 139