Dynatrace

APRIL 11, 2023

As digital transformation escalates, vulnerabilities are increasing as well, by more than 290% since 2016. Shifting left is the practice of moving testing, quality, and performance evaluation early in the development process, often before code is written. Only 27% of those CIOs say their teams fully adhere to a DevOps culture.

Cloud 180

Cloud DevOps Open Source Retail 180

Percona

JANUARY 24, 2023

Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. Such “torn pages” are corruptions from the database point of view. I couldn’t see any adverse effect on the TPS on quick tests.

Database 118

Database Benchmarking Open Source Latency 118

Percona

AUGUST 18, 2023

Why not just create another database on the same instance? Backup testing. You can run multiple instances on a server to test your backups with the correct version and configs. So you put multiple MySQL servers on a single machine instead of multiple databases inside one MySQL instance.

Programming 86

Programming Servers Database Hardware 86

Percona

FEBRUARY 2, 2023

Recall that logical replication works by using the PUB/SUB mode, where individual tables are published and are then subscribed by remotely connected databases/tables. DML operations, such as INSERT, UPDATE, DELETE, TRUNCATE, etc., are then replicated from one or more publishers to one or more subscribers.

Games 90

Games Open Source Tuning Speed 90

SQL Performance

MAY 1, 2020

In a recent tip , I described a scenario where a SQL Server 2016 instance seemed to be struggling with checkpoint times. Still, if you stack a bunch of high-transaction databases on there, checkpoint processing can get pretty sluggish. Change the Target Recovery Time of a Database. writes/sec average throughput: 46.96

C++ 58

C++ Database Servers Storage 58

SQL Performance

JULY 27, 2021

Continuing my series of articles on latches, this time I’m going to discuss the DBCC_OBJECT_METADATA latch and show how it can be a major bottleneck for consistency checks prior to SQL Server 2016 under certain circumstances. But remember, this bottleneck only happens for versions of SQL Server earlier than SQL Server 2016.

C++ 54

C++ Servers Database Code 54

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. Then, you will probably want to continue reading this section and test the code that I use as I revisit key unnesting examples that I previously demonstrated with derived tables and convert them to use CTEs. Figure 5: Execution plan for Query 5.

C++ 52

C++ Servers Code Efficiency 52

SQL Performance

JUNE 5, 2019

Reminder: Do not run ALTER DATABASE <YourDBName> SET QUERY_STORE CLEAR; against your production database unless you want to remove everything from Query Store. ALTER DATABASE [ WideWorldImporters ] SET QUERY_STORE = ON ; GO. ALTER DATABASE [ WideWorldImporters ] SET QUERY_STORE CLEAR ; GO.

Servers 41

Servers Cache Database Metrics 41

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

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. B-tree indexes are the most common index type in relational databases. JSONB Patterns & Antipatterns. JSONB Data Structures. JSONB Operators & Functions.

Storage 321

Storage Database Efficiency Processing 321

Percona

SEPTEMBER 19, 2023

This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Physical backups are the backups that consist of raw copies of the directories and files that store database contents. Copyright (c) 2016, 2023, Oracle and/or its affiliates. Type 'help' or '?'

C++ 106

C++ Servers Storage Speed 106

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 124

Performance Network Cache Metrics 124

SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. Testing different base table cardinalities is just one dimension to try. You can create supporting tables in the user database if needed.

C++ 114

C++ Servers Testing Processing 114

SQL Performance

MAY 29, 2019

From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016. FastLoadContext can be disabled on SQL Server 2016 using documented trace flag 692. DEFAULT ''. )

Cache 64

Cache Testing Servers Code 64

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

Percona

JANUARY 17, 2019

Test data and versions. For my test, I need to choose: Aurora instance type and comparison. I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). This is a significant improvement for the slow queries. Aurora instance type and comparison. MySQL on ec2.

Cache 47

Cache C++ AWS Airlines 47

SQL Performance

MAY 1, 2019

The summary rows for heap tables without indexes are the same in both documents (no changes for SQL Server 2016): An explicit TABLOCK hint is not the only way to meet the requirement for table-level locking. The following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model.

Servers 47

Servers Database Testing Performance 47

SQL Performance

SEPTEMBER 2, 2021

A lot of things change over the course of a few major versions of our favorite database platform. SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1. It’s fast, too, but it’s not perfect.

C++ 59

C++ Servers Testing Database 59

SQL Server According to Bob

JANUARY 26, 2017

“Quick question about a behavior we’re seeing at a customer and in testing. Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest.

Servers 40

Servers Database Azure Cache 40

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 Server According to Bob

JULY 13, 2016

Today we are introducing the new Basic Installer experience for SQL Server 2016 Express , SQL Server 2016 Developer , and SQL Server 2016 Evaluation Editions. We actually launched this functionality for SQL Server 2016 Express Edition when SQL Server 2016 RTM was announced but didn’t really promote this.

Servers 40

Servers Media Engineering Virtualization 40

SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. Testing different base table cardinalities is just one dimension to try. You can create supporting tables in the user database if needed.

C++ 61

C++ Servers Testing Processing 61

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

SQL Server According to Bob

APRIL 25, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40

SQL Server According to Bob

APRIL 21, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40

Smashing Magazine

OCTOBER 26, 2018

It’s an all-in-one system that is equipped with a working admin interface; it manages database connection, and has a bunch of useful APIs exposed that handle user authentication, routing, and more. on December 6th, 2016. I’m working on Varying Vagrant Vagrants , and have set up a test site with an URL [link].

Cache 78

Cache Website Speed Database 78

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Microsoft SQL Server Database Engine Input/Output Requirements. Val and Dylan performing power outage durability testing and adding new tests. The Back Story. 4 Socket, TPCC.

Servers 90

Servers Media Cache Storage 90

SQL Performance

MAY 16, 2019

Both of the following tests must pass for SQL Server to choose to set DMLRequestSort to true when inserting to an empty clustered index with table locking specified: An estimate of more than 250 rows at the input side of the Clustered Index Insert operator; and. Test ; END ; GO. DMLRequestSort Conditions. DROP TABLE dbo. DEFAULT ''. )

Cache 67

Cache Servers Testing Storage 67

Particular Software

OCTOBER 3, 2017

This article was originally published on the NDC 2016 Blog. It's a place filled with unit tests, automated integration tests, and code written using the "most latest" framework in town. Because you're on the outside of the monolith, your database technology constraints also disappear.

Architecture 49

Architecture Database Code Systems 49

O'Reilly Software

APRIL 4, 2018

Google was among the pioneers that created “web scale” architectures to analyze the massive data sets that resulted from “crawling” the web that gave birth to Apache Hadoop, MapReduce, and NoSQL databases. We usually relate SQL to querying tables in relational databases. Leverage your SQL knowledge. But what is a table?

Architecture 80

Architecture Scalability Google Operating System 80

Brendan Gregg

NOVEMBER 29, 2017

But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. My colleague Amer Ather was responsible for testing it and making it work at Netflix, and posted some of his results: [2 Million Packets Per Second on a Public Cloud Instance]. The first was c3. AWS called this [enhanced networking].

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

APRIL 23, 2019

SQL Server 2016 introduced serial batch mode processing and aggregate pushdown. You should not use it on anything except a personal test system. A clustered columnstore index is created after data population so that all of the test data ends up in a single compressed row group (no delta store). Test ( c2 ) ; GO.

Servers 67

Servers Testing Metrics Storage 67

Alex Russell

MAY 9, 2022

Improving latency and reducing variance allows teams to test other product hypotheses with less noise. Even junior PM s internalise the notion that product quality is at risk if tests are not built, automated, and tracked. These tests are expensive to run, so they must be chosen well. Protecting the Commons #.

Performance 86

Performance Latency Metrics Engineering 86

Alex Russell

APRIL 29, 2021

Thanks to the Web Platform Tests project and wpt.fyi , we have the makings of an answer for the first: Tests that fail only in a given browser. wpt.fyi 's new Compat 2021 dashboard narrows this full range of tests to a subset chosen to represent the most painful compatibility bugs : Stable-channel Compat 2021 results over time.

Media 145

Media Games Education Engineering 145

SQL Server According to Bob

FEBRUARY 10, 2019

This means we are reading database pages from the master, acquiring locks, and making calls to the domain controller (DC/KDC.). The lack of wait_info* events is revealing because if we are waiting for a database read, lock or preemptive, external call for more than 5 seconds an event would have been logged. wait_info*. Network Trace.

Servers 40

Servers Network Database Systems 40

The Symphonia

DECEMBER 6, 2017

We plan to test this out when we get the chance. Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. It’s still in early access, so no concrete news to report here, but a lot of people will be happy to be able to use a SQL database that has the operational properties of DynamoDB.

Serverless 40

Serverless Lambda AWS Traffic 40

Brendan Gregg

NOVEMBER 28, 2017

But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. My colleague Amer Ather was responsible for testing it and making it work at Netflix, and posted some of his results: [2 Million Packets Per Second on a Public Cloud Instance]. The first was c3. AWS called this [enhanced networking].

Virtualization 40

Virtualization AWS Hardware Storage 40