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. For example, find all books that are available in braille. Managing High Availability in PostgreSQL. Learn more.

Storage 321

Storage Database Efficiency Processing 321

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

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

Brendan Gregg

NOVEMBER 29, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. 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). This recommendation quickly became out of date.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

APRIL 8, 2019

These VMs are not available in all regions, so you will want to check the availability in the Azure region that you are interested in using. As 128GB DDR4 DIMMs become more widely available that total capacity will double. Both of these Intel processors are special bespoke models that are not in the Intel ARK database.

Azure 42

Azure Virtualization Storage Benchmarking 42

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.

Servers 86

Servers Tuning Database Efficiency 86

SQL Server According to Bob

JULY 12, 2016

For SQL Server 2008, 2012 and 2014 the trace flag behavior remains the same. For SQL Server 2016 the trace flags are available but the behavior may be altered by the design changes. Trace flag 2549 is used to change how DBCC sees the volume layout of the database.

Servers 40

Servers Design Engineering Database 40

All Things Distributed

SEPTEMBER 26, 2014

Topics include Introduction to AWS, Big Data, Compute & Networking, Architecture, Mobile & Gaming, Databases, Operations, Security, and more. Bootcamps you can register for include: “Getting Started with AWS,” “AWS Essentials,” “Highly Available Apps,” and “Taking AWS Operations to the Next Level.”. AWS Technical Bootcamps.

AWS 113

AWS Games Education Innovation 113

SQL Performance

MAY 16, 2019

If both sort and no-sort alternatives are available, the optimizer will make a cost-based choice. 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. If it can internally guarantee ordering in other ways, the Sort may be omitted.

Cache 67

Cache Servers Testing Storage 67

Alex Russell

APRIL 29, 2021

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. The information it captures is, however, available going back somewhat further, providing a fuller picture of the trend lines of engine completeness. Count of APIs available from JavaScript by Web Confluence.

Media 145

Media Games Education Engineering 145

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

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. DMV data is always available, so very often it's the easiest method to get a quick first look at query performance. total_worker_time / qs. ORDER BY qs.

C++ 74

C++ Database Servers Tuning 74

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 Performance

FEBRUARY 22, 2021

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. Recently one of our teams was investigating a log reader latency issue. sysprocesses.

Latency 57

Latency Servers Monitoring Systems 57

Alex Russell

JUNE 22, 2022

There's no point in recommending a better browser because none is available. The New York Times reported in late 2020 that Google now pays Apple between $8-12 billion per year , up from $1 billion in 2014. In 2014, Apple would have enjoyed a profit margin of 50% if it had spent half a billion on browser engineering. Cui bono? —

Engineering 110

Engineering Traffic Government Google 110

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. It’s further enhanced by an in-place code editor which is also available in all three views. Comparing MongoDB GUIs. Click To Tweet. NoSQLBooster.

Database 40

Database Servers Monitoring Availability 40

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

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. These threads are created when SQL Server starts, depending on the number of processor cores available for SQL Server to use. 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

Brendan Gregg

NOVEMBER 28, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. 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). This recommendation quickly became out of date.

Virtualization 40

Virtualization AWS Hardware Storage 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. Modern network performance and availability. Here begins our 2021 adventure.

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

SQL Performance

APRIL 23, 2019

SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. instructions are available. Still, when the plan generally qualifies for grouped aggregate pushdown, both pushdown (fast) and non-pushdown (slow) code paths are made available. 2 , -- print option.

Servers 67

Servers Testing Metrics Storage 67

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. The test table schema is such that 130 rows can fit on a single 8KB page when row versioning is off for the database. Available by default from SQL Server 2016 (trace flag 692 disables). Absolute minimum of I >= 100.

Cache 64

Cache Testing Servers Code 64

All Things Distributed

APRIL 4, 2017

The new AWS EU (Stockholm) Region will have three Availability Zones and will be ready for customers to use in 2018. As a result, we have opened 42 Availability Zones across 16 AWS Regions worldwide. In 2014 and 2015 respectively, AWS opened offices in Stockholm and Espoo, Finland. That’s 100% faster.

AWS 117

AWS Airlines Latency Games 117

Highly Scalable

MARCH 10, 2015

This approach can be expressed in more formal way by the following equation: where is the data available for analysis, is the space of a retailer’s actions and decisions, is an econometric model defined as a function of actions and data, and is the optimal strategy. This framework resembles the approach suggested in [JK98].

Retail 152

Retail C++ Analytics Metrics 152

O'Reilly

JULY 25, 2023

To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022. This choice also inspired me to call my project Swift Papers. But still, I liked how Moment.js

Programming 98

Programming Code Design Benchmarking 98