SQL Performance

SEPTEMBER 5, 2019

This article explores the batch data normalized representation, explains why not all eight-byte data types can fit within 64 bits, and shows an example of how all this affects batch-mode performance. You will need SQL Server 2016 (or later) and Developer Edition (or equivalent) to reproduce the results shown here. c1 = @Start + N.

Performance 81

Performance C++ Storage Servers 81

SQL Performance

SEPTEMBER 25, 2019

Performance spools are lazy spools added by the optimizer to reduce the estimated cost of the inner side of nested loops joins. An example plan shape showing a lazy table performance spool is below: The questions I set out to answer in this article are why, how, and when the query optimizer introduces each type of performance spool.

Performance 104

Performance Cache Servers Education 104

Dynatrace

APRIL 11, 2023

Today’s organizations face increasing pressure to keep their cloud-based applications performing and secure. As data from different corners of the enterprise proliferates, teams need a better way to bring data together to identify performance and security issues, minimize security risk, and drive greater business value.

Cloud 186

Cloud DevOps Open Source Retail 186

Alex Russell

MAY 9, 2022

Despite advances in browser tooling , automated evaluation , lab tools , guidance , and runtimes , however, teams struggle to deliver even decent performance with today's popular frameworks. What is Performance? It may seem a silly question, but what is performance, exactly?

Performance 86

Performance Latency Metrics Engineering 86

Percona

SEPTEMBER 19, 2023

29 will let you set up redo log directory while performing a backup. Copyright (c) 2016, 2023, Oracle and/or its affiliates. Press ^C to stop. Press ^C to stop. PXB considers the log sequence number and starts copying away the data files when a backup is performed. for help; 'quit' to exit.

C++ 102

C++ Servers Storage Speed 102

Scalegrid

JANUARY 19, 2024

Therefore, companies must carefully consider key performance metrics and methodologies to stay relevant and successful in timely and trend-oriented markets. The persistent record maintained through journaling ensures durability and provides additional assurance for all performed writing operations within the database.

Database 130

Database Network Servers Monitoring 130

SQL Performance

APRIL 20, 2021

We are now ready to start the query scan, perform some early phase processing, and start the first additional parallel tasks. A reminder of the plan ( click to enlarge ): This is the first point in the process so far that an in-flight execution plan is available (SQL Server 2016 SP1 onward) in sys.dm_exec_query_statistics_xml.

C++ 98

C++ Processing Servers Cache 98

Brendan Gregg

OCTOBER 8, 2018

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. Attaching 2 probes. ^C bcc is powerful but laborious to program. variable this->name $name.

C++ 110

C++ Virtualization Programming Latency 110

SQL Performance

DECEMBER 9, 2020

I’ll present the performance tests that I’ve done with my solution. What’s the best performing solution that you can conjure? To evaluate the performance of your solution and compare it with others, I’ll test it with the range 1 through 100,000,000, with Discard results after execution enabled in SSMS. So, the challenge is on!

C++ 61

C++ Servers Testing Processing 61

Brendan Gregg

DECEMBER 21, 2019

For my AWS re:Invent talk on BPF Performance Analysis at Netflix, I began with a demo of "BPF superpowers" (aka eBPF). Embedded C. # # Tone generation from: [link] # # 29-Apr-2019 Brendan Gregg Created this. My [BPF Performance Tools] book has plenty of examples. strength: -46 strength: -46 strength: -45 strength: -45 [.]

C++ 52

C++ Education Java AWS 52

Brendan Gregg

DECEMBER 21, 2019

For my AWS re:Invent talk on BPF Performance Analysis at Netflix, I began with a demo of "BPF superpowers" (aka eBPF). Embedded C. # # Tone generation from: [link] # # 29-Apr-2019 Brendan Gregg Created this. My [BPF Performance Tools] book has plenty of examples. usr/bin/python # # iwlstrength.py The source is: #!/usr/local/bin/bpftrace

C++ 52

C++ Education Java AWS 52

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. Can't filter duplicates.

Database 109

Database Servers C++ AWS 109

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. Kendra Little – Target Recovery Interval and Indirect Checkpoint – New Default of 60 Seconds in SQL Server 2016. SQL 2016 – It Just Runs Faster: Indirect Checkpoint Default. group_id = c.

C++ 58

C++ Database Servers Storage 58

Percona

JANUARY 17, 2019

In this article, we will look at how this can improve the reporting/analytical query performance in MySQL. I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). Result: ~10x performance gain, no index used. Summary of simple query performance. MySQL on ec2.

Cache 46

Cache C++ AWS Airlines 46

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”. price ) AS bottomprice , LAST ( C. LAST ( C.

C++ 73

C++ Virtualization Servers Code 73

Percona

AUGUST 18, 2023

Cases where (in very large sharded deployments) a user will install multiple mysqlds per server to reduce contention, i.e., they get more performance per 2-socket server with four or eight mysqlds than one. That said, other performance motivations mentioned above did play into it, especially before the days of multi-threaded replication.

Programming 82

Programming Servers Database Hardware 82

SQL Performance

JULY 1, 2019

On SQL Server 2014 and earlier, the plan is: For SQL Server 2016 or later, you will see: Both plans are safe, but for different reasons. The more complex SQL Server 2016+ plan does not use the ANY aggregate at all. Reproducing the bug in SQL Server 2016+. This plan shape is always safe, since no ANY aggregates are used.

C++ 58

C++ Servers Database Performance 58

SQL Performance

OCTOBER 29, 2019

There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). Extended Events provides data about the individual execution of queries, while Query Store and the DMVs aggregate performance data. CustomerID , c. Customers c JOIN Sales.

C++ 74

C++ Database Servers Tuning 74

SQL Performance

SEPTEMBER 2, 2021

SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT().

C++ 59

C++ Servers Testing Database 59

All Things Distributed

DECEMBER 8, 2016

Lululemon Athletica is a Canadian athletic apparel company that is using AWS Lambda, AWS CodePipeline, and AWS CodeDeploy to rapidly build and deploy their digital marketing and e-commerce solutions for the upcoming 2016 holiday season. Performance. Par Werner Vogels, le 8 décembre 2016. Performance.

AWS 155

AWS Cloud Lambda Innovation 155

Brendan Gregg

OCTOBER 7, 2018

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. Attaching 2 probes. ^C bcc is powerful but laborious to program. variable this->name $name.

C++ 40

C++ Virtualization Programming Latency 40

Percona

JUNE 4, 2023

Critical features of MariaDB include robust security features like encryption at rest and in transit, user authentication, and role-based access control (RBAC), as well as high-performance query execution, advanced indexing techniques, and replication, clustering, and sharding, ensuring scalability and high availability. What is MySQL?

Open Source 52

Open Source Servers Storage Scalability 52

Randon ASCII

JANUARY 22, 2017

In August of 2016 Chrome switched meta-build systems, from gyp to gn. It’s also peculiar because log2f is a C Run-Time (CRT) function, which shouldn’t be supplied by Blink anyway. The symbol search order is unspecified by C++ and due to the One Definition Rule (ODR) the search order should not matter.

C++ 56

C++ Code Systems Processing 56

Brendan Gregg

SEPTEMBER 5, 2017

LTS (April 2016). I wrote about it in a previous post, [DTrace for Linux 2016]. Hit Ctrl-C to end. ^C C operation = 'read' usecs : count distribution 0 -> 1 : 0 | | 2 -> 3 : 0 | | 4 -> 7 : 4479 | *| 8 -> 15 : 1028 | | 16 -> 31 : 14 | | 32 -> 63 : 1 | | [.]. The hardest part on Linux is now done: kernel support.

Virtualization 76

Virtualization AWS Engineering Hardware 76

John McCalpin

NOVEMBER 5, 2016

In recent years the trend has been to increase core-level performance by the use of SIMD vector instructions, and to increase package-level performance by the addition of more and more cores. Notes on notation: C[i][j] is invariant in the innermost loop, so I refer to the values in the accumulator as elements of the C array.

Cache 40

Cache C++ Latency Hardware 40

Alex Russell

SEPTEMBER 12, 2016

Instead, this article focuses on the strictest common criteria to ensure broad installability as of late 2016. In US educational terms, doing well in these criteria will be the difference between a C- and an A-: Mobile-friendly design. Performance testing is difficult! Similarly, per-browser criteria are not cataloged.

Mobile 52

Mobile Network Education Design 52

Smashing Magazine

FEBRUARY 8, 2022

In 2016, I released the first version of the tool, then called not Statoscope, but Webpack Runtime Analyzer. Statoscope processes the stats, performs analysis and provides a visual representation to interpret the results in a convenient form: ( Large preview ). It turns out that suddenly a double of Package C appears in your bundle.

Storage 79

Storage Code Metrics C++ 79

SQL Server According to Bob

JANUARY 5, 2017

By March of 2016 Slava had convinced me to join the team. Find those same concepts for software and you can do the exact same things, no virtualization and no performance or functionality compromises. int c = a + b; 0134167C 8B 45 F8 mov eax,dword ptr [a]. 01341682 89 45 E0 mov dword ptr [c],eax.

Servers 40

Servers Operating System C++ Software Engineering 40

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. Should have an excellent way to measure server and query performance. View query performances with visual explain plans. Click To Tweet.

Database 40

Database Servers Monitoring Availability 40

SQL Server According to Bob

AUGUST 23, 2016

I had an interesting e-mail discussion related to the performance of create table. We are not talking about the performance of inserts, updates, deletes and selects but instead looking at the time it takes to perform create table. These are additional steps that a disk based table does not perform.

C++ 40

C++ Software Engineering Servers Code 40

Nick Desaulniers

NOVEMBER 20, 2016

clang -c x.c Also, when you want to rebuild or update your binary, you spend time performing relocation again and again with static libraries. What if we could set aside object files that we could share amongst multiple instances of the same or even different processes, and perform relocation at runtime? y.c $ ar -rv libhello.a

C++ 48

C++ Programming Code Virtualization 48

Percona

JANUARY 14, 2019

With the latest ClickHouse version, all of these features are available, but some of them may not perform fast enough. Updating a single message in the past (e.g. in the case of messages, we may need to update the final price; in the case of comments, we may need to upvote or downvote a comment). Deleting messages. Text search.

Database 40

Database Analytics Blockchain Healthcare 40

Randon ASCII

FEBRUARY 25, 2018

In September of 2016 we started noticing random failures when building Chrome – 3 out of 200 builds of Chrome failed when protoc.exe, one of the executables that is part of the build, crashed with an access violation. The next step was a custom C++ program that opened the just-linked exe and called FlushFileBuffers on it.

Programming 79

Programming Hardware Cache Code 79

Particular Software

OCTOBER 3, 2017

This article was originally published on the NDC 2016 Blog. Repeat this process until you've captured all the important actions as events your monolith is performing. Your service could be written using the latest C# language version making use of the Elvis operator, etc. Code that had duplication all over the place?

Architecture 49

Architecture Database Code Systems 49

Smashing Magazine

OCTOBER 26, 2018

In recent years, the industry thankfully started paying more attention to performance. As a result, website performance can suffer. Improving performance with the decoupled JSON approach. on December 6th, 2016. Improving Performance With The Decoupled JSON Approach. Working with the default WordPress REST API.

Cache 78

Cache Website Speed Database 78

SQL Server According to Bob

DECEMBER 18, 2018

Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The “forced flush” changes in SQL Server avoid flushes, when possible, in order to improve performance on non-optimized Fua file systems. Performance points of reference: The following charts highlight the increase in performance.

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

JANUARY 28, 2018

DtcGetTransactionManager contacts the host, performing a remote registry access to determine the connection and proxy information. The MSDTC proxy communicates with the MSDTC (A) service to perform a begin transaction and the method returns an ITransaction pointer. extern “C” { extern struct xa_switch_t msqlsrvxa1; }.

Servers 40

Servers Azure Engineering Java 40