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. This warning may mainly apply to users building their PostgreSQL from source code.

Database 142

Database Benchmarking Open Source Latency 142

SQL Server According to Bob

SEPTEMBER 26, 2016

The result is a design for SQL Server 2016 that provides high availability for the most demanding workloads on the latest hardware with minimal impact and scalable for the future. However, if you are looking to accelerate your hardware, our Always On Availability Group design for SQL Server 2016 can keep pace. one without a replica).

Availability 40

Availability Servers Hardware Benchmarking 40

SQL Performance

AUGUST 11, 2021

Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. In my examples, I’ll use the sample database TSQLV5. END ) / @bucketwidth * @bucketwidth , @origin ) ; Notice that the code uses the week part this time.

Azure 139

Azure Code Database Servers 139

Percona

APRIL 12, 2023

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. 2016: The company adds service-loaded MongoDB Professional to its mix.

Open Source 98

Open Source Programming Database Servers 98

SQL Performance

AUGUST 14, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Run the following code to create the Transactions table and populate it with sample data: SET NOCOUNT ON ; USE TSQLV5 ; -- [link]. DROP TABLE IF EXISTS dbo. Transactions. (

Best Practices 108

Best Practices Servers Database Azure 108

SQL Performance

DECEMBER 9, 2020

You can create supporting tables in the user database if needed. Use the following code to run a test with base CTE cardinality of 2 (requires 5 additional levels of CTEs): DECLARE @low AS BIGINT = 1 , @high AS BIGINT = 100000000 ; WITH. As an example, see the ones I submit at the end of this article. You can add hints as needed.

C++ 114

C++ Servers Testing Processing 114

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

O'Reilly

FEBRUARY 4, 2025

They were succeeded by programmers writing machine instructions as binary code to be input one bit at a time by flipping switches on the front of a computer. Then, development of even higher-level compiled languages like Fortran, COBOL, and their successors C, C++, and Java meant that most programmers no longer wrote assembly code.

Programming 145

Programming Google Infrastructure Internet 145

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. ( SELECT S. orderdate ) FROM dbo.

C++ 52

C++ Servers Code Efficiency 52

Adrian Cockcroft

JANUARY 29, 2023

I presented this analysis of response time distributions talk in 2016 — at Microxchg in Berlin ( video ). The code is written using the R statistics language and I downloaded a free copy of RStudio to run the examples below. > I’ve been thinking about this for a long time. of the largest peak, the ones that are visible in the plot.

Lambda 98

Lambda Latency Cache C++ 98

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. The sqllang!CUpdUtil::FOptimizeInsert

Cache 64

Cache Testing Servers Code 64

SQL Performance

JUNE 22, 2021

The FGCB_ADD_REMOVE latch protects a data structure called an FGCB, or File Group Control Block, and there will be one of these latches for each online filegroup of each online database in a SQL Server instance. There are many concurrent operations requiring space to be allocated (e.g. a constant insert workload from many client connections).

Servers 54

Servers Database Performance Code 54

SQL Performance

JULY 9, 2019

The ISO/IEC 9075:2016 standard (SQL:2016) defines a feature called nested window functions. For example, suppose that you want to query the Sales.OrderValues view in the TSQLV5 sample database, and return for each customer and order date, the daily total of the order values, and the running total until the current day.

Servers 83

Servers Availability Database Code 83

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. Borrowing and adapting code from a previous post, Examining the Performance Impact of an Adhoc Workload , we will first create two stored procedures.

C++ 74

C++ Database Servers Tuning 74

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. You’d think the sequence numbers would start at 1 for a brand-new database, but that is not the case. To prove it, I ran this code: SELECT.

Architecture 53

Architecture Servers Virtualization Database 53

SQL Performance

APRIL 10, 2019

The ISO/IEC 9075:2016 standard, or SQL:2016 in short, introduces support for a profound concept called Row Pattern Recognition (RPR) in SQL. The SQL:2016 standard provides two main RPR-related features: Feature R010, “Row pattern recognition: FROM clause”. . ( Ticker ; CREATE TABLE dbo. STOCK1 2019-02-12 150.00

C++ 73

C++ Servers Virtualization Code 73

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. That is to ensure your database is encrypted at the file level. The process to enable this for a database is described in our documentation. What does encrypted mean at this point?

Servers 40

Servers Database Azure Cache 40

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

Particular Software

OCTOBER 3, 2017

This article was originally published on the NDC 2016 Blog. Code that had duplication all over the place? Chances are you were dealing with legacy code that was written years ago. In my 15+ years of coding, every single time I've dealt with legacy code, fear, anger, hate, and suffering were pretty common.

Architecture 49

Architecture Database Code Systems 49

Smashing Magazine

JANUARY 21, 2019

A component is simply a set of pieces of HTML, JavaScript and CSS code put all together to create an autonomous entity. Following, the API will add the database object data. In other words, database object data is normalized. Recommended reading : A GraphQL Primer: Why We Need A New Kind Of API.

Social Media 73

Social Media Database Media Website 73

SQL Performance

DECEMBER 9, 2020

You can create supporting tables in the user database if needed. Use the following code to run a test with base CTE cardinality of 2 (requires 5 additional levels of CTEs): DECLARE @low AS BIGINT = 1 , @high AS BIGINT = 100000000 ; WITH. As an example, see the ones I submit at the end of this article. You can add hints as needed.

C++ 61

C++ Servers Testing Processing 61

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. In 2016, O’Reilly published “ Designing For Sustainability ” by Tim Frick. Many efforts are afoot to improve the situation on the web.

Website Performance 78

Website Performance Website Energy Performance 78

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. and he thought it was cool.

Google 52

Google Transportation Programming Innovation 52

Alex Russell

APRIL 29, 2021

After 20 years of neck-in-neck competition, often starting from common code lineages, there just isn't that much left to wring out of the system. At the time of the last Confluence run, the gap had stretched to nearly 1000 APIs, doubling since 2016. Healthy competition features various parties trading the lead with regularity.

Media 145

Media Games Education Engineering 145

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

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

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

C++ Servers Testing Performance 46

SQL Performance

APRIL 23, 2019

SQL Server 2016 introduced serial batch mode processing and aggregate pushdown. Still, when the plan generally qualifies for grouped aggregate pushdown, both pushdown (fast) and non-pushdown (slow) code paths are made available. Each scan output batch (of up to 900 rows) makes a runtime decision between the fast and slow code paths.

Servers 67

Servers Testing Metrics Storage 67

SQL Performance

MAY 7, 2019

The execution of SQL Server’s internal code is done using a mechanism called threads. Each thread can be executing SQL Server code, and multiple threads coordinate together when a query runs in parallel. A scheduler has three basic ‘parts’: The processor , which has exactly one thread currently executing code. Scheduling.

Servers 40

Servers Metrics Azure Tuning 40

Alex Russell

MAY 9, 2022

Who owns this code? Teams in this space can make trades intelligently, moving around code and time within a system they have mastered to ensure the best possible outcomes in essential flows. miAi3020A9G #perfmatters 1 10:04 AM · Jul 7, 2016. Organisations sometimes spiral into recrimination and mistrust. Why is it there?

Performance 99

Performance Latency Metrics Engineering 99

The Symphonia

DECEMBER 6, 2017

Specific improvements include A new code editor for those who write their Lambda functions in Javascript and Python, far superior to the old inline code-editor. we have powerful laptops and are perfectly happy with a combination of IntelliJ and the rapidly evolving VS Code editor from Microsoft. But we’re keeping an open mind.

Serverless 40

Serverless Lambda AWS Traffic 40

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

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. Red Hat, SUSE, HPE, Intel helping and confirming Linux behaviors and making file system code changes. The Back Story.

Servers 90

Servers Media Cache Storage 90

Smashing Magazine

OCTOBER 26, 2018

Because of its history and for being sort of a fork of an old blogging platform called “b2” (more details here ), it’s largely written in a procedural way (using function-based code). Before we delve deeper in the code, a couple more things about WordPress REST API. on December 6th, 2016. Large preview ). Transients API.

Cache 88

Cache Website Speed Testing 88

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. SQL Server also supports XA based transactions but has no code in the SQL Server engine to engage in XA transactions. MSDTC can also be used as the XA TM if so desired (see example code at end of this post.). Transaction Monitor/Manager – Coordinator.

Servers 40

Servers Azure Engineering Java 40