Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. How would you _time_ time?

Speed 126

Speed Java AWS Virtualization 126

SQL Performance

FEBRUARY 1, 2022

You can’t specify how many VLFs are created by SQL Server when the database is first created or the log file automatically grows, but you can influence it. Prior to SQL Server 2014, when the log file auto grows, the number of new VLFs added to the end of the log file is determined by the algorithm above, based on the auto-grow size.

Architecture 53

Architecture Servers Virtualization Database 53

SQL Performance

JULY 27, 2021

You might wonder why I’m writing about an issue that affects older versions, but there are still a huge number of SQL Server 2014 and older instances out there, so it's a valid topic for my series. I strongly recommend you read the initial post in the series before this one, so you have all the general background knowledge about latches.

C++ 54

C++ Servers Database Code 54

SQL Performance

SEPTEMBER 29, 2021

Joe Sack went into detail about this enhancement added back in SQL Server 2014: “ Exploring Low Priority Lock Wait Options in SQL Server 2014 CTP1.”. First, we’ll create two new databases: CREATE DATABASE NewWay ; CREATE DATABASE OldWay ; GO. SQL Server Partition Switching Example. Schema Transfer. seconds.

Servers 55

Servers Games Database Processing 55

Scalegrid

JULY 17, 2020

Why should a relational database even care about unstructured data? JSON database in 9.2 It is useful to validate incoming JSON and store in the database. 2014) added support for JSONB data type. B-tree indexes are the most common index type in relational databases. JSONB Patterns & Antipatterns. JSONB Indexes.

Storage 321

Storage Database Efficiency Processing 321

Adrian Cockcroft

JANUARY 31, 2023

Their database model later become known as NoSQL, although it was implemented on top of Oracle, each database held one table and indexes, and there were many sharded Oracle databases for each data set so it could be scaled horizontally as well. That’s going to take more than one blog post to summarize…

Google 52

Google Transportation Programming Innovation 52

High Scalability

JUNE 22, 2018

using them to respond to storage events on s3 or database events or auth events is super easy and powerful. Ultimately, Netflix did end up paying Comcast in 2014 and, surprise surprise, the throttling stopped. Xtracerx : for me the biggest value to serverless functions is how nicely they tie in to the ecosystem of a cloud provider.

Internet 113

Internet Internet Scalability Artificial Intelligence 113

SQL Performance

MAY 1, 2019

The following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model. For SQL Server 2014 and later , the transition point is 950 rows for this table. The thresholds are not dependent on the Cardinality Estimation model in use or the database compatibility level.

Servers 47

Servers Database Testing Performance 47

Uber Engineering

JANUARY 12, 2016

The making of Schemaless, Uber Engineering’s custom designed datastore using MySQL, which has allowed us to scale from 2014 to beyond. By Jakob Holdgaard Thomsen. This is part one of a three-part series on Schemaless.

Scalability 102

Scalability Design Engineering Database 102

Brendan Gregg

NOVEMBER 29, 2017

It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. When I joined Netflix in 2014, we had begun transitioning from PV to HVM (PVHVM). But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. This recommendation quickly became out of date.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49

Servers Azure Hardware Database 49

Uber Engineering

JANUARY 19, 2016

The details and examples of Schemaless triggers, a key feature of the datastore that’s kept Uber Engineering scaling since October 2014.

Engineering 94

Engineering Design Database Architecture 94

Uber Engineering

JANUARY 15, 2016

How Uber’s infrastructure works with Schemaless, the datastore using MySQL that’s kept Uber Engineering scaling since October 2014. This is part two of a three- part series on Schemaless; part one is on designing Schemaless.

Architecture 81

Architecture Infrastructure Engineering Design 81

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. How would you _time_ time?

Speed 40

Speed Java AWS Virtualization 40

Percona

AUGUST 27, 2018

5000 named Percona to their list in 2013, 2014, 2015 and 2016. Peter frequently speaks as an expert lecturer at MySQL and related conferences, and regularly posts on the Percona Database Performance Blog. Peter was an early employee at MySQL AB, eventually leading the company’s High-Performance Group.

Open Source 42

Open Source Internet Internet Strategy 42

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. “SQL Server 2016 running on the same hardware as SQL Server 2014, 2012, 2008, 2008 R2 or 2005 uses fewer resources and executes a wide range of workloads faster.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. Test Environment. BountyAmount.

Servers 86

Servers Tuning Database Efficiency 86

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. How would you time time?

Speed 52

Speed Java AWS Virtualization 52

SQL Server According to Bob

JULY 12, 2016

For SQL Server 2008, 2012 and 2014 the trace flag behavior remains the same. Trace flag 2549 is used to change how DBCC sees the volume layout of the database. Trace flags 2562 and 2549 are documented in knowledgebase article: [link] and the blog post [link] highlights the SQL 2016 DBCC performance improvements.

Servers 40

Servers Design Engineering Database 40

SQL Server According to Bob

SEPTEMBER 26, 2016

As we moved towards SQL Server 2014, the pace of hardware accelerated. Our design for SQL Server 2012 and SQL Server 2014 is still proven and meets the demands for many of our customers. The yellow line represents throughput results for SQL Server 2014 with a single sync replica. Direct seeding of new database replicas.

Availability 40

Availability Servers Hardware Benchmarking 40

All Things Distributed

SEPTEMBER 26, 2014

Topics include Introduction to AWS, Big Data, Compute & Networking, Architecture, Mobile & Gaming, Databases, Operations, Security, and more. When: October 1, 2014 at 6:30 -8:00 PM. AWS Technical Bootcamps. CircleCI, NPM, Lyft, Librato, Cotap, Runscope and others will be featured speakers during our evening happy hours.

AWS 113

AWS Games Education Innovation 113

SQL Performance

MAY 16, 2019

For SQL Server 2014 and later, the uniquifier is correctly omitted for unique indexes, but the one extra byte for the internal bit flag is retained. The following script should be run on a development SQL Server instance in a new test database set to use the SIMPLE or BULK_LOGGED recovery model. 61 bytes * 269 rows = 16,409 bytes.

Cache 67

Cache Servers Testing Storage 67

SQL Performance

APRIL 8, 2019

Both of these Intel processors are special bespoke models that are not in the Intel ARK database. The older Intel Xeon E5-26xx v3 (Haswell) series which was introduced in Q3 of 2014, had a maximum memory bandwidth of 2133MHz. I wrote about using CPU-Z to benchmark the Intel Xeon E5-2673 v3 processor in an Azure VM in this article.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Performance

OCTOBER 29, 2019

In order to use Query Store and Extended Events, you have to configure them in advance – either enabling Query Store for your database(s), or setting up an XE session and starting it. [ dbid ] ) AS [ Database Name ] , REPLACE ( REPLACE ( LEFT ( t. [ SELECT TOP ( 50 ) DB_NAME ( t. [

C++ 74

C++ Database Servers Tuning 74

SQL Server According to Bob

JUNE 3, 2016

The following chart shows the same 1TB database testing. Use SQL Server Management Studio (SSMS) or your favorite query editor to connect to a SQL Server 2012 or 2014 instance. SQL Server 2014. MultiObjectScanner = Older design. CheckScanner = New design. Paste the script below in a new query window. or newer release.

Hardware 40

Hardware Cache Servers Software Engineering 40

SQL Performance

FEBRUARY 22, 2021

And while it doesn't have an explicit deprecation warning, the official documentation for the DBCC command has this gentle nudge: Starting with SQL Server 2014 (12.x) But dbid is unreliable and marginally useful anyway, particularly for cross-database queries; there's much better info in sys.dm_tran_locks. sysprocesses.

Latency 57

Latency Servers Monitoring Systems 57

The Morning Paper

AUGUST 27, 2019

I am so pleased to see a database systems paper addressing the concerns of the application developer! A example class of application invariants is database integrity constraints. See Coordination avoidance in database systems for more details. Interactive checks for coordination avoidance Whittaker & Hellerstein et al.,

Programming 59

Programming Processing Database Systems 59

Alex Russell

JUNE 22, 2022

World-class experts in graphics, networking, cryptography, databases, language design, VM implementation, security, usability (particularly usable security), power management, compilers, fonts, high-performance layout, codecs, real-time media, audio and video pipelines, and per- OS specialisation are required.

Engineering 110

Engineering Traffic Government Google 110

SQL Performance

JULY 1, 2019

Nevertheless, if you run this query yourself, you are quite likely to see the same result I do: The execution plan depends on the version of SQL Server used, and does not depend on database compatibility level. The Distinct Sort plan contains an ANY aggregate, but the Distinct Sort operator implementation does not manifest the bug.

C++ 58

C++ Servers Database Performance 58

Scalegrid

AUGUST 15, 2019

In 2014, we discussed 4 of the top MongoDB GUIs: MongoVue, MongoHub, RockMongo, and Robo 3T (formerly Robomongo), and again in 2016: MongoDB Compass, Robo 3T, Studio 3T, and MongoBooster. Whether you're exploring your local #MongoDB database or working with shards and replica sets, @Studio3T allows you to do all of it. Click To Tweet.

Database 40

Database Servers Monitoring Availability 40

Brendan Gregg

NOVEMBER 28, 2017

It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. When I joined Netflix in 2014, we had begun transitioning from PV to HVM (PVHVM). But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. This recommendation quickly became out of date.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

JULY 16, 2019

This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile. You might be asking why you should care about all of this as a SQL Server Database professional? Figure 2: AMD EPYC Rome Processor. How is This Relevant for SQL Server? There are many reasons!

Servers 46

Servers Hardware Architecture Retail 46

Alex Russell

APRIL 29, 2021

Delayed three years ( Chrome 40, November 2014 vs. Safari 11.1, A subset ( element.animate() ) has enabled developers to more easily create high-performance visual effects with lower risk of visual stuttering in Chrome and Firefox since 2014. Critical in adapting web content to mobile, particularly regarding multi-touch gestures.

Media 145

Media Games Education Engineering 145

SQL Performance

MAY 7, 2019

Back in 2014, I started a series of blog posts here to talk about specific wait types and what they do and don’t mean. That gave me the idea to create the wait and latches libraries that I maintain (more on these later). If you’re reading this and thinking “what is he talking about?” then this post is for you.

Servers 40

Servers Azure Metrics Tuning 40

Alex Russell

MARCH 6, 2021

Devices and networks have evolved too: Alex Russell @slightlylate An update on mobile CPUs and the Performance Inequality Gap: Mid-tier Android devices (~$300) now get the single-core performance of a 2014 iPhone and the multi-core perf of a 2015 iPhone. mid-priced Androids were slightly faster than 2014's iPhone 6.

Performance 124

Performance Network Cache Metrics 124

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo.

Servers 95

Servers Tuning Architecture Processing 95