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. They do a much better job than what was available in PostgreSQL (pglz).

Database 119

Database Benchmarking Open Source Latency 119

All Things Distributed

OCTOBER 17, 2016

It brings the worldwide total of AWS Availability Zones (AZs) to 38, and the number of regions globally to 14. In the remainder of 2016 and inq 2017, we will launch another four AWS regions in Canada, China, the United Kingdom, and France, adding another nine AZs to our global infrastructure footprint.

AWS 127

AWS Cloud Infrastructure Storage 127

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Text search.

Database 40

Database Analytics Blockchain Healthcare 40

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. For example, find all books that are available in braille. B-tree indexes are the most common index type in relational databases. JSONB Data Structures.

Storage 321

Storage Database Efficiency Processing 321

SQL Performance

JUNE 5, 2019

Neither is ideal, and when you simply have too many queries asking for more memory than is available to grant, you’ll see RESOURCE_SEMAPHORE waits. Reminder: Do not run ALTER DATABASE <YourDBName> SET QUERY_STORE CLEAR; against your production database unless you want to remove everything from Query Store. ) ; GO.

Servers 41

Servers Cache Database Metrics 41

All Things Distributed

JUNE 20, 2017

The new AWS Asia Pacific (Hong Kong) Region will have three Availability Zones and be ready for customers for use in 2018. As a result, we have opened 43 Availability Zones across 16 AWS Regions worldwide. Since then, AWS has added two more PoPs in Hong Kong, the latest in 2016. In 2013, AWS opened an office in Hong Kong.

AWS 149

AWS Logistics Cloud Social Media 149

SQL Server According to Bob

JULY 12, 2016

Trace flags 2562 and 2549 are documented in knowledgebase article: [link] and the blog post [link] highlights the SQL 2016 DBCC performance improvements. For SQL Server 2016 the trace flags are available but the behavior may be altered by the design changes. This is behavior is unchanged in SQL Server 2016.

Servers 40

Servers Design Engineering Database 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 Performance

NOVEMBER 1, 2019

The product is not released yet, at least at the time of writing, but they have started to shape which features (and there are a lot of them ) will be available in which editions. I wrote about this in a post entitled, " A Big Deal : SQL Server 2016 Service Pack 1." Accelerated Database Recovery is in Standard Edition.

Servers 40

Servers Hardware Database Availability 40

SQL Server According to Bob

NOVEMBER 8, 2016

SQL Server 2016 Service Pack 1 (all SKUs) , in combination with Windows Server 2016 (All SKUs) or Windows 10 Client introduces non-volatile memory support for the tail of the log file (LDF) which can significantly increase transaction throughput. Create / Alter Database … LOG ON. Tail Of Log Caching.

Cache 40

Cache Servers Media Storage 40

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. Modern network performance and availability. The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively.

Performance 124

Performance Network Cache Metrics 124

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. We left those at the end of this post for your review.

Database 40

Database Servers Monitoring Availability 40

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). With faster disks (i.e. AWS Aurora (based on MySQL 5.6) MySQL on ec2.

Cache 47

Cache C++ Airlines AWS 47

SQL Performance

AUGUST 11, 2021

One is using a function called DATE_BUCKET , which at the time of writing is only available in Azure SQL Edge. 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.

Azure 139

Azure Code Database Servers 139

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 more complex SQL Server 2016+ plan does not use the ANY aggregate at all. Reproducing the bug in SQL Server 2016+.

C++ 58

C++ Servers Database Performance 58

SQL Server According to Bob

JANUARY 26, 2017

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. That is to ensure your database is encrypted at the file level.

Servers 40

Servers Database Azure Cache 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

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

JULY 9, 2019

The ISO/IEC 9075:2016 standard (SQL:2016) defines a feature called nested window functions. This feature is currently not available in T-SQL. At the date of this writing, there's not much information available out there about the true standard nested window functions. What nested window functions are not about.

Availability 83

Availability Servers Database Code 83

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.

Latency 57

Latency Servers Monitoring Systems 57

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

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

Adrian Cockcroft

JANUARY 29, 2023

I presented this analysis of response time distributions talk in 2016 — at Microxchg in Berlin ( video ). A later version of the slides is included in my Microservices Workshop deck from later that year, slides 168–200 ( pdf , keynote are available in GitHub.com/adrianco/slides ). I’ve been thinking about this for a long time.

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.

Cache 64

Cache Testing Servers Code 64

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. You can find coverage of RPR, including illustrated examples, in a 90-page technical report ISO/IEC TR 19075-5 (available for free).

C++ 73

C++ Virtualization Servers Code 73

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

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

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

SQL Performance

MAY 7, 2019

These threads are created when SQL Server starts, depending on the number of processor cores available for SQL Server to use. The waiter list , which has all the threads that are basically stuck, waiting for a particular resource to become available. Waits Resources. You can get to the library at [link].

Servers 40

Servers Azure Metrics Tuning 40

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. 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.

Virtualization 111

Virtualization AWS Hardware Storage 111

Particular Software

OCTOBER 3, 2017

This article was originally published on the NDC 2016 Blog. And doing this is simple, especially if you're using an available library like NServiceBus or MassTransit. It turned out that an RPC call to a legacy service, whose response value was stored in the 72nd column in the database table, wasn't even necessary.

Architecture 49

Architecture Database Code Systems 49

SQL Performance

MAY 16, 2019

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

Cache 67

Cache Servers Testing Storage 67

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. Filesystem Type 1K-blocks Used Available Use% Mounted on. The Back Story. Fua (Forced Unit Access).

Servers 90

Servers Media Cache Storage 90

The Symphonia

DECEMBER 6, 2017

Traffic shaping / canary deployment was pre-announced at Serverless Conf NYC in October, and this is now available. there’s no inline debugging available in the Lambda Console.) Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. We plan to test this out when we get the chance.

Serverless 40

Serverless Lambda AWS Traffic 40

Smashing Magazine

JANUARY 21, 2019

Following, the API will add the database object data. This information is not placed under each module, but under a shared section called databases , to avoid duplicating information when two or more different modules fetch the same objects from the database. In other words, database object data is normalized.

Social Media 64

Social Media Database Media Website 64

SQL Performance

APRIL 23, 2019

SQL Server 2016 introduced serial batch mode processing and aggregate pushdown. 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. SQL Server does not cross a 64-bit boundary when packing bits.

Servers 67

Servers Testing Metrics Storage 67