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

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. JSON is faster to ingest vs. JSONB – however, if you do any further processing, JSONB will be faster. JSONB Patterns & Antipatterns. JSONB Data Structures.

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 '?' X, but got no.

C++ 100

C++ Servers Storage Speed 100

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. In Part 4 of the series, which focused on optimization of derived tables, I described a process of unnesting/substitution of table expressions. You can find the script that creates and populates TSQLV5 here , and its ER diagram here.

C++ 52

C++ Servers Code Efficiency 52

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

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

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. Advances in browser content processing. The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively.

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++ 61

C++ Servers Testing Processing 61

Percona

JUNE 4, 2023

Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. It is largely an unofficial response to published comments from the MariaDB Corporation. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

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

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. 10 percent processed.

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. 10 percent processed.

Servers 40

Servers Database Processing Virtualization 40

O'Reilly Software

APRIL 4, 2018

We live in the era of the connected experience, where our daily interactions with the world can be digitized, collected, processed, and analyzed to generate valuable insights. Accumulating all this data to process overnight is not an option anymore. Do we need to process each record individually? Process tolerance.

Architecture 80

Architecture Scalability Google Operating System 80

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. These events can then be used to trigger other downstream business processes. Code that had duplication all over the place?

Architecture 49

Architecture Database Code Systems 49

SQL Performance

APRIL 23, 2019

This eliminated unnecessary row-mode processing, and removed the need for an exchange. SQL Server 2016 introduced serial batch mode processing and aggregate pushdown. The execution plan shows the result of fast-path pushdown processing as ‘locally aggregated rows’ with no corresponding row output from the scan.

Servers 67

Servers Testing Metrics Storage 67

Alex Russell

MAY 9, 2022

Effective managers understand that products require processes to manage, yet front-end discourse assumes that switching frameworks will introduce a golden age. Improving latency and reducing variance allows teams to test other product hypotheses with less noise. Only teams that master their systems can make intentional trade-offs.

Performance 86

Performance Latency Metrics Engineering 86

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. Recommended reading : WordPress Security As A Process. on December 6th, 2016. Let’s create a small test plugin.

Cache 78

Cache Website Speed Database 78

Brendan Gregg

NOVEMBER 29, 2017

AWS EC2 uses a different image type and boot process for PV and HVM, as described on the [Linux AMI Virtualization Types] page. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. This was extended to instance storage devices for the x1.32xlarge in 2016. The first was c3. Impressive!

Virtualization 111

Virtualization AWS Hardware Storage 111

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

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. We don’t recommend using this as a regular process for production use, but it might come in handy at development time. Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. Also allows for creating new files in line. Step Functions.

Serverless 40

Serverless Lambda AWS Traffic 40

Brendan Gregg

NOVEMBER 28, 2017

AWS EC2 uses a different image type and boot process for PV and HVM, as described on the [Linux AMI Virtualization Types] page. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. This was extended to instance storage devices for the x1.32xlarge in 2016. The first was c3. Impressive!

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. Microsoft specific implementation for DTC using (OLE-TX). X/Open Standard for TM to RM communications and behavior. Transaction Monitor/Manager – Coordinator. Microsoft MSDTC protocol. Transaction GUID used by MSDTC, often referred to as a UOW (Unit-of-Work).

Servers 40

Servers Azure Engineering Java 40