SQL Performance

FEBRUARY 22, 2021

I would like to share a couple of recent examples that help illustrate how using deprecated SQL Server features continues to bite us. The system table sys.sysprocesses was replaced way back in SQL Server 2005 by a set of dynamic management views (DMVs), most notably sys.dm_exec_requests , sys.dm_exec_sessions , and sys.dm_exec_connections.

Latency 57

Latency Servers Monitoring Systems 57

All Things Distributed

NOVEMBER 13, 2018

The AWS Europe (Milan) Region will have three Availability Zones and be ready for customers in early 2020. Currently we have 57 Availability Zones across 19 technology infrastructure Regions. In 2012, Amazon opened its first Italian office and its first Italian point of presence (PoP) based in Milan. million unique visits.

AWS 167

AWS Energy Automotive Traffic 167

All Things Distributed

SEPTEMBER 25, 2012

By Werner Vogels on 25 September 2012 06:00 PM. By the way, for mission critical OLTP workloads, you should also consider adding the Amazon RDS Multi-AZ option to improve availability. Within a week the latency for end-users was cut in half and there were no longer performance fluctuations in their architecture. Comments ().

Cloud 117

Cloud AWS Storage Database 117

The Netflix TechBlog

AUGUST 29, 2023

Since there were no existing solutions available, we needed to build them ourselves. To improve availability, we designed systems where components could fail separately and avoid single points of failure. There is a downside to fetching this data on-demand: this adds latency to the first request to a cluster.

Traffic 220

Traffic Latency Cloud C++ 220

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

Smashing Magazine

AUGUST 20, 2021

Yet, for all these technological developments, it’s interesting that many of us are still serving sites in the same way Tim did with the very first website — a web server serving static website files. ’ Before MovableType, other personal blogging platforms were available such as Geocities , Blogger & Open Diary.

Ecommerce 139

Ecommerce Website Government Internet 139

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 useful when customers want to use different origin servers for different types of content. All Things Distributed. Dynamic Content Support in Amazon CloudFront.

Cache 117

Cache Latency AWS Website 117