SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. The following chart shows the same 1TB database testing. SQL Server 2016. or newer release.

Hardware 40

Hardware Cache Servers Software Engineering 40

Scalegrid

JANUARY 19, 2024

For example, memory-resident databases without persistent disks, such as Redis cluster setups or Apache Spark installations, rely on stand-alone machines. To traditional relational databases, where rollbacks are less likely to cause data loss, MongoDB differs significantly.

Database 130

Database Network Servers Monitoring 130

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. Use the following code to create the Employees table in the tempdb database, populate it with sample data, and create a supporting index: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. Employees ; GO. CREATE TABLE dbo. Employees. (

C++ 140

C++ Servers Code Efficiency 140

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 Shack

SEPTEMBER 29, 2020

SQL Server PolyBase Introduction It is a new feature from SQL Server 2016 to query the relational and non-relational database using data virtualization techniques. In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups.

Servers 99

Servers Availability Virtualization Database 99

Percona

JULY 30, 2018

Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). 5000 named Percona to their list in 2013, 2014, 2015 and 2016. Register Now.

Architecture 41

Architecture Database Open Source Internet 41

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

Database 40

Database Analytics Blockchain Healthcare 40

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

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 88

Games Open Source Tuning Speed 88

Dynatrace

APRIL 11, 2023

As digital transformation escalates, vulnerabilities are increasing as well, by more than 290% since 2016. Meanwhile, traditional databases have demonstrated limitations in increasingly complex and distributed cloud-native environments. As organizations develop new applications, vulnerabilities will continue to emerge.

Cloud 195

Cloud DevOps Open Source Retail 195

Percona

AUGUST 18, 2023

Why not just create another database on the same instance? We split databases by function/team to give each team full autonomy over their schema, And if someone screws up, it breaks their cluster, not all databases. So you put multiple MySQL servers on a single machine instead of multiple databases inside one MySQL instance.

Programming 83

Programming Servers Database Hardware 83

SQL Performance

MARCH 20, 2020

In SQL Server 2016, STRING_SPLIT solved a long-missing gap in a language that, admittedly, was not intended for complicated string processing. For years before SQL Server 2016 (and for years since), we've written our own versions, improved them over time, and even argued about whose was fastest. Thanks for listening!

Database 109

Database Servers C++ AWS 109

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 is generally referred to as “ partial page writes ” or “ torn pages.”

Database 115

Database Benchmarking Open Source Latency 115

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. Use the following code to create the Employees table in the tempdb database, populate it with sample data, and create a supporting index: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. Employees ; GO. CREATE TABLE dbo. Employees. (

C++ 52

C++ Servers Code Efficiency 52

All Things Distributed

OCTOBER 17, 2016

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. It brings the worldwide total of AWS Availability Zones (AZs) to 38, and the number of regions globally to 14. The Ohio Region is no different.

AWS 127

AWS Cloud Infrastructure Analytics 127

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

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 80

Open Source Programming Database Servers 80

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

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 Code Performance 54

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

Dynatrace

OCTOBER 15, 2021

Cloud databases excel at storing large volumes of information for later reference, and this data often has business value or privacy restrictions. This occurs once data is safely stored within a local cache. This is common in on-premises or hybrid deployments, where time series data and tags are transmitted to the cloud. Span ingestion.

Open Source 226

Open Source Metrics Cloud Transportation 226

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. SQL standard added support for JSON in SQL - SQL/JSON Standard-2016. JSONB Indexes.

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

C++ Servers Storage Speed 104

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

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. So why does SQL Server pick 37 and not 1 for the first VLF sequence number?

Architecture 53

Architecture Servers Virtualization Database 53

SQL Performance

JUNE 9, 2021

That is, ones that are created as an object in the database, and stay there permanently unless dropped. In my examples I’ll use a sample database called TSQLV5. A table could be a base table defined as an object in the database, or it could be a table returned by an expression—more specifically, a table expression.

Database 140

Database Code Design Development 140

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.

Google 52

Google Transportation Programming Innovation 52

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 Podelko

OCTOBER 20, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. I decided to publish a few parts here to see if anything triggers a discussion. It would be published as separate posts: – Introduction (a short teaser).

Performance Testing 100

Performance Testing Architecture Testing Performance 100

Percona

JANUARY 17, 2019

I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). MySQL on ec2. mysql> show global variables like '%version%'; + -+ + | Variable_name | Value | + -+ + | innodb_version | 5.6.41-84.1 sec) The table is very wide, 84 columns.

Cache 46

Cache C++ AWS Airlines 46

SQL Performance

JULY 16, 2019

From 2007 until 2016, Intel was able to successfully execute their Tick-Tock release strategy, where they would introduce a new processor microarchitecture roughly every two years (a Tock release). This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46

Servers Hardware Architecture Retail 46

All Things Distributed

JUNE 20, 2017

Since then, AWS has added two more PoPs in Hong Kong, the latest in 2016. Beyond running their web properties and applications, Next Digital also uses Amazon RDS (database), Amazon ElastiCache (caching), and Amazon Redshift (data warehousing). In 2013, AWS opened an office in Hong Kong.

AWS 149

AWS Logistics Cloud Social Media 149

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

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

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

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