Dynatrace

AUGUST 12, 2019

With OneAgent installed on an application server, Davis, the Dynatrace AI causation engine, continuously analyzes all database statements within the context of your applications. In this way, Dynatrace can tell you which statements need your attention. Slow requests – For example, due to a single lengthy SQL query.

Database 127

Database Metrics Cache Servers 127

HammerDB

OCTOBER 23, 2023

and explains how to measure the difference between running with and without stored procedures. and explains how to measure the difference between running with and without stored procedures. As an example from the TPC-C specification, this is the Stock Level procedure. What is a stored procedure?

Benchmarking 62

Benchmarking Database Network C++ 62

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. What is a Trigger in MySQL?

Cache 61

Cache Database Games Healthcare 61

SQL Performance

SEPTEMBER 6, 2022

Instead, the question I’ll address here is exactly how and when lock escalation is triggered. I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. WITH ( TABLOCKX ) ( i , lob ) SELECT.

Database 98

Database Storage Testing Servers 98

SQL Performance

MAY 13, 2020

Last month I provided a background to table expressions in T-SQL. I explained the context from relational theory and the SQL standard. I explained how a table in SQL is an attempt to represent a relation from relational theory. Window functions can appear only in a query's SELECT and ORDER BY clauses.

C++ 143

C++ Code Design Servers 143

SQL Performance

SEPTEMBER 9, 2020

I describe T-SQL’s support for recursive CTEs, as well as standard elements that are not yet supported by T-SQL. I do provide logically equivalent T-SQL workarounds for the unsupported elements. This article is the sixth part in a series about table expressions. This month I cover the logical treatment of recursive CTEs.

C++ 143

C++ Code Servers Availability 143

Percona

FEBRUARY 2, 2023

DML operations, such as INSERT, UPDATE, DELETE, TRUNCATE, etc., are then replicated from one or more publishers to one or more subscribers. The only real limitation is that one can only publish tables from a read-write server such as the PRIMARY. For the most part it’s a pretty straightforward operation.

Games 90

Games Open Source Tuning Speed 90

SQL Performance

MARCH 30, 2021

This five-part series takes a deep dive into the way SQL Server row mode parallel plans start up. To provide a concrete basis for the analysis, we will follow how a particular parallel query starts execution. To provide a concrete basis for the analysis, we will follow how a particular parallel query starts execution.

Cache 98

Cache Servers Operating System Processing 98

Percona

OCTOBER 10, 2023

When on-prem or DBaaS like RDS or Cloud SQL, it is relatively straightforward to apply a change. In this blog post, I’ll provide some thoughts on how schema changes can be performed when running MySQL on Kubernetes I won’t focus on DIRECT ALTERs as it is pretty straightforward to apply them. We are going to create a Job.

Database 96

Database Performance C++ Engineering 96

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. I will finish by also clarifying some of the common misconceptions people have about replication and how Percona can help. The idea is to use secondary servers on your infrastructure for either reads or other administrative solutions.

Servers 52

Servers Database Availability Traffic 52

Percona

AUGUST 25, 2023

3308", "primaryCluster": "Cluster1", "status": "HEALTHY", "statusText": "All Clusters available." } How failover happens inside a single InnoDB Cluster Connect to any node of the first cluster (“cluster1”) via MySQLShell and fetch the details. 3308" } Now perform a primary switchover from the instance (“127.0.0.1:3308”)

Traffic 77

Traffic Database C++ Servers 77

Percona

JULY 15, 2023

This blog was originally published in January 2022 and was updated in July 2023. Starting from MySQL 8.0.13, functional indexes are supported. In this article, I will first explain an overview of indexes in MySQL and cover the MySQL CREATE INDEX before diving into showing what functional indexes are and how they work.

Virtualization 78

Virtualization Speed Database Efficiency 78

SQL Performance

OCTOBER 26, 2021

The SQL Server query optimizer makes use of statistics during query compilation to help determine the optimal query plan. The Problem With Synchronous Statistics Updates. Synchronously updating statistics before compilation obviously introduces a delay and makes the query take longer to compile and execute. Introduction.

Servers 55

Servers Metrics Database Performance 55

Dynatrace

APRIL 16, 2019

Many of our customers also run their.NET, ASP.NET,NET Core, SQL Server, CRM, SharePoint … applications on AWS and have reached out to us in the past to ask about best practices around optimizing these workloads in order to run more efficiently and more cost effective. Step #1: Install Dynatrace. Install OneAgents on your EC2 machines.

AWS 126

AWS Best Practices Database Traffic 126

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. Understanding the importance of MySQL backups and how they can reduce these risks will help organizations guarantee data consistency, business continuity, and the assurance that their data is safe and recoverable when needed.

Best Practices 80

Best Practices Storage Strategy Database 80

SQL Performance

AUGUST 27, 2021

Continuing my series of articles on latches, this time I’m going to discuss the APPEND_ONLY_STORAGE_INSERT_POINT latch and show how it can be a major bottleneck for heavy update workloads where either form of snapshot isolation is being used. To explain this latch, I need to explain a little bit about how snapshot isolation works.

Database 56

Database Storage Availability Servers 56

HammerDB

FEBRUARY 25, 2021

This is why the choice of programming language is so important from the outset. It is important that the concurrency between sessions is handled at the database not at the client because that is how databases are accessed in the real world. The following is an example from TPROC-C from SQL Server.

Programming 67

Programming Benchmarking Virtualization C++ 67

SQL Performance

JULY 11, 2019

Last year, I got together with one of my dev teams at SentryOne – they call themselves the SQL Injectors – to talk about the possibility of replicating Plan Explorer functionality inside of Azure Data Studio. How You Get It. Connecting to SQL Server 2012 or better, or Azure SQL Database. or better).

Azure 90

Azure Servers Tuning Operating System 90

SQL Performance

JANUARY 8, 2020

Last month I introduced the NULL as SQL's marker for any kind of missing value. I explained that SQL doesn't provide you with the ability to distinguish between missing and applicable (A-values) and missing and inapplicable (I-values) markers. This article is the second in a series on NULL complexities. NULL treatment inconsistencies.

Design 65

Design C++ Code Database 65

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. Depending on the version of MySQL you are running , some of the default values used in this post may differ from your install, but the premise is still largely the same. What are the Benefits of MySQL Performance Tuning?

Tuning 52

Tuning Database Performance Hardware 52

SQL Performance

APRIL 13, 2020

In addition to seeing how often an index is used (or not), it's beneficial to know what queries use an index, particularly if I'm looking to merge it with another index. Query Store can help with that – I've modified his query to get the same information from the plans in Query Store: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED.

Tuning 137

Tuning Cache Metrics Testing 137

SQL Performance

JUNE 17, 2021

Both can experience blocking when foreign key relationships are checked by the SQL Server engine. Both can experience blocking when foreign key relationships are checked by the SQL Server engine. The same essential issue can lead to unexpected (and arguably illogical) transaction failures due to apparent update conflicts.

Database 57

Database Servers Testing Azure 57

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). SQL Server makes some timing adjustments in parallel plans to promote consistency, but they are not perfectly implemented.

Servers 95

Servers Tuning Architecture Processing 95

SQL Performance

SEPTEMBER 2, 2021

UPDATE: September 2nd, 2021 (Originally published July 26th, 2012.). 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. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1.

C++ 59

C++ Servers Testing Database 59

SQL Performance

AUGUST 15, 2019

Updated August 15th, 2019 for 0.9.6. Last year, I got together with one of my dev teams here – they call themselves the SQL Injectors – to talk about the possibility of replicating SentryOne Plan Explorer functionality inside of Azure Data Studio. How You Get It. Select File > Install Extension from VSIX Package.

Azure 50

Azure Servers Tuning Operating System 50

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. TestHeap WITH ( TABLOCK ) ( c1 ) SELECT TOP ( 897 ) CHECKSUM ( NEWID ( ) ) FROM master.

Servers 47

Servers Database Testing Performance 47

HammerDB

OCTOBER 12, 2018

As with the previous guides as an Intel employee (#IAMINTEL) the examples are taken from a MySQL 8 on Linux on Intel system and the approach is the same for whatever system you are testing although some of the settings you see may be different. HammerDB difference from Sysbench. SELECT DISTINCT c from sbtest where id between ?

Best Practices 40

Best Practices Scalability Performance C++ 40

Percona

AUGUST 27, 2018

In this post, I’m going to take a look at how these might work in practice. It is well hidden in the Optimization: Optimizing the MySQL Server chapter. MySQL determines, at startup, how many virtual CPUs are available. Essentially, you can assign a thread to a specific virtual CPU. Let us start with a disclaimer.

Tuning 45

Tuning Virtualization Testing Servers 45

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. © ​​ 2004 Microsoft Corporation. .

Servers 40

Servers Cache Media Hardware 40

SQL Performance

JUNE 5, 2019

One of the more perplexing problems to troubleshoot in SQL Server can be those related to memory grants. SQL Server’s optimizer estimates how much memory is needed, and the query must obtain the memory grant in order to start executing. sort, hash). If it underestimates memory, then you can see spills in tempdb.

Servers 41

Servers Cache Database Metrics 41

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. This White Paper is for informational purposes only.

Servers 40

Servers Cache Database Media 40

Sutter's Mill

MARCH 11, 2024

Software security ” (or “cybersecurity” or similar) means making software able to protect its assets from a malicious attacker. Software safety ” (or “life safety” or similar) means making software free from unacceptable risk of causing unintended harm to humans, property, or the environment. Acknowledgments.

C++ 139

C++ Programming Code Java 139

HammerDB

NOVEMBER 30, 2018

This Git repository is updated with every release. This guide to HammerDB concepts and architectures is aimed at helping you understand how HammerDB is built and how it can be extended and modified. In fact all of this source code is also included in readable form with each and every release. Programming Languages.

Architecture 40

Architecture Virtualization Open Source C++ 40

SQL Server According to Bob

DECEMBER 31, 2018

How It Works: XEvent Output and Visualization SQL Server Management Studio Provides–“XE Profiler” Use the SSMS XEvent Profiler. Using SQL Server Management Studio (SSMS) and storing the events in a table requires reading the events, streaming to table storage followed by an order by event sequence query.

Efficiency 40

Efficiency Code Servers Cache 40

The Netflix TechBlog

OCTOBER 23, 2019

Jeremy Smith , Jonathan Indig , Faisal Siddiqi We are pleased to announce the open-source launch of Polynote : a new, polyglot notebook with first-class Scala support, Apache Spark integration, multi-language interoperability including Scala, Python, and SQL, as-you-type autocomplete, and more. which makes heavy use of Scala?—?with

Open Source 233

Open Source Code Website Design 233

The Netflix TechBlog

OCTOBER 23, 2019

Jeremy Smith , Jonathan Indig , Faisal Siddiqi We are pleased to announce the open-source launch of Polynote : a new, polyglot notebook with first-class Scala support, Apache Spark integration, multi-language interoperability including Scala, Python, and SQL, as-you-type autocomplete, and more. which makes heavy use of Scala?—?with

Open Source 107

Open Source Code Website Design 107

The Netflix TechBlog

OCTOBER 23, 2019

Jeremy Smith , Jonathan Indig , Faisal Siddiqi We are pleased to announce the open-source launch of Polynote : a new, polyglot notebook with first-class Scala support, Apache Spark integration, multi-language interoperability including Scala, Python, and SQL, as-you-type autocomplete, and more. which makes heavy use of Scala?—?with

Open Source 100

Open Source Code Website Design 100