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 246

Cloud DevOps Open Source Retail 246

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. You can take advantage of this effort packaged in SQL Server 2016. SQL 2016 supports 3X more physical memory than previous versions. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 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

SQL Server According to Bob

JUNE 15, 2016

There is a MSVC, runtime library patch needed by SQL Server 2016 and without the patch the SQL Server service can simply terminate (crash.) Furthermore, our Smart Setup technology can detect the SQL Server Critical Update when installing a new SQL Server 2016 instance and apply this automatically.

Software Engineering 40

Software Engineering Servers Database Engineering 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 246

Open Source Metrics Cloud Transportation 246

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 107

AWS Cloud Infrastructure Storage 107

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 Servers Cache Software Engineering 40

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 59

Architecture Database Open Source Internet 59

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

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

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 142

Database Benchmarking Open Source Latency 142

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.

Open Source 117

Open Source Games Tuning Servers 117

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

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

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 127

Performance Network Mobile Metrics 127

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 125

AWS Logistics Cloud Social Media 125

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

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

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 98

Programming Servers Database Open Source 98

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 72

Cache C++ AWS Airlines 72

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. There are two common pitfalls involving window functions, both of which are the result of counterintuitive implicit defaults that are imposed by the SQL standard.

Best Practices 108

Best Practices Servers Database Azure 108

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

C++ Servers Storage Speed 124

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

AUGUST 27, 2018

5000 named Percona to their list in 2013, 2014, 2015 and 2016. Peter frequently speaks as an expert lecturer at MySQL and related conferences, and regularly posts on the Percona Database Performance Blog. Peter was an early employee at MySQL AB, eventually leading the company’s High-Performance Group.

Open Source 64

Open Source Internet Internet Strategy 64

Percona

FEBRUARY 1, 2024

This blog was originally published in June 2016 but was updated in February 2024.In In this blog post, we’ll look at various MySQL high availability (HA) solutions, detailing their advantages and disadvantages to equip you with the insight required for informed decision-making regarding your database infrastructure.

Availability 52

Availability Infrastructure Database 52

O'Reilly

APRIL 5, 2023

Worse yet, the AI’s bias would likely find its way into the system’s database and follow the students from one class to the next. In 2016, Microsoft’s Tay chatbot was shut down after making racist and sexist comments.

Artificial Intelligence 123

Artificial Intelligence Energy Government Virtualization 123

SQL Performance

DECEMBER 9, 2020

You can create supporting tables in the user database if needed. The upside of option 1 is that it works in all SQL Server editions and is relevant in SQL Server 2016 or later, since the batch mode Window Aggregate operator was introduced in SQL Server 2016. As an example, see the ones I submit at the end of this article.

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

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. You can find the script that creates and populates TSQLV5 here and its ER diagram here. DATE_BUCKET.

Azure 139

Azure Code Database Servers 139

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

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

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

Brendan Gregg

NOVEMBER 29, 2017

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. This was because most of our workloads are CPU and memory bound, which were already virtualized in hardware. The first was c3.

Virtualization 110

Virtualization AWS Hardware Storage 110

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. [ dbid ] ) AS [ Database Name ] , REPLACE ( REPLACE ( LEFT ( t. [ SELECT TOP ( 50 ) DB_NAME ( t. [

C++ 74

C++ Database Servers Tuning 74

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