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

SQL Server According to Bob

JUNE 6, 2016

As indicated, SQL Server 2016 added the use of SSE and AVX instructions in various code paths to improve performance. SQL Server asks the CPU if it supports SSE or AVX in order to determine the level of hardware support present on the system. My recent posts. have generated discussions about the SSE and AVX support boundaries.

Servers 40

Servers Hardware Software Engineering Software 40

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. On the same hardware/machine repeat steps 1 thru 3 using an instance of SQL Server 2016 CTP 3.0

Hardware 40

Hardware Servers Cache Software Engineering 40

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. In 2016, Jio swept over the subcontinent like a monsoon dropping a torrent of 4G infrastructure and free data rather than rain.

Performance 127

Performance Network Mobile Metrics 127

John McCalpin

OCTOBER 16, 2016

“Memory Bandwidth and System Balance in HPC Systems” If you are planning to attend the SuperComputing 2016 conference in Salt Lake City next month, be sure to reserve a spot on your calendar for my talk on Wednesday afternoon (4:15pm-5:00pm).

Architecture 40

Architecture Systems Technology Technology 40

Alex Podelko

OCTOBER 20, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. System’s configuration is not given anymore and often can’t be easily mapped to hardware. – Cloud. – Agile. – Continuous Integration.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

Brendan Gregg

FEBRUARY 28, 2023

Make sure your system can handle next-generation DRAM,” [link] Nov 2011 - [Hruska 12] Joel Hruska, “The future of CPU scaling: Exploring options on the cutting edge,” [link] Feb 2012 - [Gregg 13] Brendan Gregg, “Blazing Performance with Flame Graphs,” [link] 2013 - [Shimpi 13] Anand Lal Shimpi, “Seagate to Ship 5TB HDD in 2014 using Shingled Magnetic (..)

Performance 103

Performance Latency Cache Google 103

All Things Distributed

DECEMBER 12, 2018

The second platform is a managed IoT cloud with customer-facing applications and data management, which went live in 2016. If the solution works as envisioned, Telenor Connexion can easily deploy it to production and scale as needed without an investment in hardware. Our AWS Europe (Stockholm) Region is open for business now.

AWS 119

AWS Cloud Games Serverless 119

The Morning Paper

MAY 21, 2019

” This paper describes a “far memory” system that has been in production deployment at Google since 2016. Using zswap means that no new hardware solutions are required, enabling rapid deployment across clusters. The far memory system has been deployed in production since 2016. Evaluation.

Software 78

Software Software Google Hardware 78

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. In all versions of MySQL – at least at the time of writing – when you run a single query it will run in one thread, effectively utilizing one CPU core only. With faster disks (i.e. sec). /* another run */.

Cache 72

Cache C++ AWS Airlines 72

Tim Kadlec

JANUARY 9, 2019

Hardware gets better, sure. Cennydd also makes the case that performance also has an impact on energy consumption: In 2016, video, tracking scripts and sharing buttons caused the average website to swell to the same size as the original version of Doom. It makes sense.

Performance 111

Performance Energy Internet Internet 111

Brendan Gregg

JULY 4, 2021

This was a chance to talk about other things I've been working on, such as the present and future of hardware performance. BBR: Congestion-Based Congestion Control,” [link] 2016 - [Gregg 16] Brendan Gregg, “Unikernel Profiling: Flame Graphs from dom0,” [link] Jan 2016 - [Gregg 16b] Brendan Gregg, “Linux 4.X

Performance 52

Performance Latency Hardware Storage 52

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46

Servers Hardware Architecture Retail 46

Brendan Gregg

SEPTEMBER 5, 2017

LTS (April 2016). I wrote about it in a previous post, [DTrace for Linux 2016]. I wrote a page on it: [perf]. - **eBPF**: tracing features completed in 2016, this provides efficient programmatic tracing to existing kernel frameworks. The hardest part on Linux is now done: kernel support. It's the official profiler.

Virtualization 75

Virtualization AWS Engineering Hardware 75

Percona

AUGUST 18, 2023

The original motivation for FB was due to different hardware generations, especially between regions/data centers. Cases where (in very large sharded deployments) a user will install multiple mysqlds per server to reduce contention, i.e., they get more performance per 2-socket server with four or eight mysqlds than one.

Programming 98

Programming Servers Database Open Source 98

SQL Performance

JUNE 21, 2019

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. SQL Server Database Maintenance plans prior to SQL Server 2016 only allowed to rebuild or reorganize all indexes.

Servers 49

Servers Azure Hardware Database 49

Alex Russell

APRIL 29, 2021

At the time of the last Confluence run, the gap had stretched to nearly 1000 APIs, doubling since 2016. is access to hardware devices. This allows customisation and use of specialised features without custom, proprietary software for niche hardware. Some commenters appear to confuse unlike hardware for differences in software.

Media 145

Media Games Education Engineering 145

SQL Server According to Bob

NOVEMBER 29, 2016

Back in June, Bob Dorr gave you the thinking behind why SQL Server 2016 It Just Runs Faster due to changes in our SQL Server and NUMA configurations. Bob blogged about a new SQL Server 2016 feature called Auto Soft NUMA. First, we see a message like this (Note: We made a fix in 2016 SP1 because this used to say 8 logical processors).

Servers 45

Servers Virtualization Scalability Hardware 45

Randon ASCII

FEBRUARY 25, 2018

In this particular investigation, which spanned twenty months, we suspected hardware failure, compiler bugs, linker bugs, and other possibilities. Jumping too quickly to blaming hardware or build tools is a classic mistake, but in this case the mistake was that we weren’t thinking big enough.

Programming 79

Programming Hardware Cache Code 79

SQL Server According to Bob

JULY 13, 2016

desktop machine (I won’t tell you the hardware details. Today we are introducing the new Basic Installer experience for SQL Server 2016 Express , SQL Server 2016 Developer , and SQL Server 2016 Evaluation Editions. Go install it”. So I proceeded to install SQL Server 4.20 on my Windows NT 3.1 It would scare you).

Servers 40

Servers Media Engineering Virtualization 40

O'Reilly Software

APRIL 4, 2018

In 2016, Apache Spark introduced Structured Streaming , a new streaming engine based on the SparkSQL abstractions and runtime optimizations. It enables unbounded scalability as more commodity or specialized hardware can be seamlessly added to existing clusters. In the same year, Apache Flink announced streaming SQL support.

Architecture 80

Architecture Scalability Google Operating System 80

Brendan Gregg

FEBRUARY 28, 2023

Make sure your system can handle next-generation DRAM,” [link] , Nov 2011 [Hruska 12] Joel Hruska, “The future of CPU scaling: Exploring options on the cutting edge,” [link] , Feb 2012 [Gregg 13] Brendan Gregg, “Blazing Performance with Flame Graphs,” [link] , 2013 [Shimpi 13] Anand Lal Shimpi, “Seagate to Ship 5TB HDD in 2014 using Shingled Magnetic (..)

Performance 52

Performance Latency Cache Google 52

Alex Russell

OCTOBER 22, 2017

This, in turn, drives the single most important trend in setting the global web performance budget hardware baseline: the next billion users will largely come online when they can afford to. The true median device from 2016 sold at about ~$200 unlocked. — Monica Dinculescu (@notwaldorf) September 20, 2016.

Performance 74

Performance Network Benchmarking Mobile 74

SQL Performance

NOVEMBER 1, 2019

As you may recall, back in SQL Server 2016 SP1, they opened up all of the programming surface features to all editions, and many (but certainly not all) of the performance and availability features. I wrote about this in a post entitled, " A Big Deal : SQL Server 2016 Service Pack 1."

Servers 40

Servers Hardware Database Availability 40

Rigor

MARCH 20, 2018

I wrote a blog in 2016 that discussed the need for businesses to flip the traditional monitoring investment pyramid on its head. Instead of focusing on hardware and infrastructure first, technical teams should first ensure that they first have visibility on the thing that drives the business: their customer experience.

Monitoring 40

Monitoring Retail Ecommerce Infrastructure 40

Smashing Magazine

JANUARY 15, 2019

how much data does the browser have to download to display your website) and resource usage of the hardware serving and receiving the website. In 2016, O’Reilly published “ Designing For Sustainability ” by Tim Frick. There are, however, some good fallbacks which we can use that demonstrate energy usage.

Website Performance 78

Website Performance Website Energy Performance 78

John McCalpin

NOVEMBER 5, 2016

In the latest (October 2016) revision of Intel’s Instruction Extensions Programming Reference , Intel has disclosed a fairly dramatic departure from these “traditional” approaches. Does anyone else see the introduction of “vector+SIMD” instructions as an important precedent?

Cache 40

Cache C++ Latency Hardware 40

Dynatrace

OCTOBER 28, 2021

Chaos engineering matured at organizations such as Netflix, and gave rise to technologies such as Gremlin (2016) , becoming more targeted and knowledge-based. Thus, the tool Chaos Monkey was born. Because it can touch many systems, chaos engineering can have broad implications, affecting groups and stakeholders across the organization.

Engineering 264

Engineering Entertainment Cloud Infrastructure 264

Brendan Gregg

NOVEMBER 29, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance. I'd expect between 0.1%

Virtualization 110

Virtualization AWS Hardware Storage 110

Smashing Magazine

OCTOBER 27, 2021

Nowadays, hardware and software are designed to conduct eye-tracking studies for marketing , UX , psychological and medical research , gaming , and several other use cases. However, the price of eye-tracking used to be much higher than heatmaps, as measuring users’ gaze required special hardware to be used in-lab.

Mobile 128

Mobile Website Hardware Social Media 128

Alex Russell

FEBRUARY 21, 2023

Before Safari 15, Apple only delivered two substantial releases per year, a pattern that had been stable since 2016: New features were teased at WWDC in the early summer They landed in a Fall dot-oh release with the new iOS version A second set of feature updates would trickle out as part of a Spring point-one update.

Energy 90

Energy Games Engineering Design 90

SQL Server According to Bob

DECEMBER 18, 2018

Linux may need similar utilities to control various hardware cache installations. You should always validate the Fua capabilities with your device and hardware vendor. To accommodate a wide range of installations and hardware required four (4) options across SQL Server and the HE. Fua = Forced Unit Access. Device Flush.

Servers 90

Servers Media Cache Storage 90

Brendan Gregg

NOVEMBER 28, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance. I'd expect between 0.1%

Virtualization 40

Virtualization AWS Hardware Storage 40

The Agile Manager

FEBRUARY 29, 2020

RIM exited the handset business in 2016. The firm's capital mix (debt stifles change, equity does not), capital allocation processes (waterfall gatekeeping stifles adaptability), how it sees the products it makes (software and data are more lucrative than hardware), how it operates (deploy many times a day), must all change.

Artificial Intelligence 52

Artificial Intelligence Social Media Automotive Mobile 52