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

C++ Servers Testing Processing 114

KeyCDN

JANUARY 31, 2019

With Bucharest being the capital and largest city of Romania, it makes for a great edge server location. However, now with the Bucharest edge server in production, it helps further close the gap between visitors who live in Romania and the nearest KeyCDN POP they have access to. As of 2016, Bucharest alone had a population of over 1.83

Internet 48

Internet Internet Ecommerce Speed 48

Brendan Gregg

OCTOBER 8, 2018

bpftrace has most of DTrace's capabilities and more. ## bpftrace The prior work that led to [bpftrace] (aka BPFtrace) is discussed my earlier [DTrace for Linux 2016] post, which explains how the Linux kernel gained [eBPF]: the virtual machine that we're using to run tracing programs. bcc is powerful but laborious to program.

C++ 110

C++ Virtualization Programming Latency 110

KeyCDN

OCTOBER 24, 2018

With Helsinki being the capital and most populous municipality of Finland, it makes for a great edge server location. However, now with the Helsinki edge server in production, this helps further close the gap between visitors who live in Finland and the nearest KeyCDN POP they have access to. As of 2016, there were just over 5.1

Internet 48

Internet Internet Speed Network 48

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

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. Each option has pros and cons.

C++ 74

C++ Database Servers Tuning 74

Brendan Gregg

OCTOBER 7, 2018

bpftrace has most of DTrace's capabilities and more. ## bpftrace The prior work that led to [bpftrace] (aka BPFtrace) is discussed my earlier [DTrace for Linux 2016] post, which explains how the Linux kernel gained [eBPF]: the virtual machine that we're using to run tracing programs. bcc is powerful but laborious to program.

C++ 40

C++ Virtualization Programming Latency 40

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. 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. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49

Servers Azure Hardware Database 49

Percona

FEBRUARY 2, 2023

The only real limitation is that one can only publish tables from a read-write server such as the PRIMARY. Instead, failing over is, in fact, not a single action but a collection of discrete steps that must be performed in an exact and precise manner. Stay tuned folks; the game is afoot. And, of course, timing is critical.

Games 92

Games Open Source Tuning Speed 92

Brendan Gregg

SEPTEMBER 5, 2017

LTS (April 2016). I wrote about it in a previous post, [DTrace for Linux 2016]. I wrote a page on it: [perf]. - **eBPF**: tracing features completed in 2016, this provides efficient programmatic tracing to existing kernel frameworks. The hardest part on Linux is now done: kernel support. It's the official profiler.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Rigor

SEPTEMBER 3, 2019

What you may be overlooking is that peak-event readiness is about more than just load testing or ensuring that your servers are up throughout a specific timeframe. How are you monitoring end-user performance today? Rigor’s free performance report. STEP 2: Use Synthetic Monitoring to Baseline Your Current Performance.

Website 74

Website Cache Ecommerce Traffic 74

KeyCDN

MARCH 10, 2021

It's our mission to continuously improve web performance and each POP contributes to it. With Tel Aviv being the technology capital of Israel, it's the ideal edge server location. Performance report Brisbane - Australia Brisbane is our 4th POP in Australia. The new POP ensures better performance along the East Coast.

Latency 110

Latency Internet Internet Tuning 110

Alex Russell

MARCH 31, 2022

The best available proxy data also suggests that shared caches would have a minimal positive effect on performance. Like every other successful platform, the web operates on a finely tuned understanding of risk and trust , and deprecations are particularly explosive. [2] and SFTP -ing one's dependencies to the server are gone.

Cache 82

Cache Government Traffic Network 82

Percona

JANUARY 17, 2019

In this article, we will look at how this can improve the reporting/analytical query performance in MySQL. I will compare AWS Aurora with MySQL (Percona Server) 5.6 84.1 | | version_comment | Percona Server (GPL), Release 84.1, Result: ~10x performance gain, no index used.

Cache 47

Cache C++ AWS Airlines 47

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

SQL Performance

MAY 7, 2019

I’m going to introduce you to wait statistics and explain how critical they are for troubleshooting workload performance in SQL Server. The execution of SQL Server’s internal code is done using a mechanism called threads. When that happens, SQL Server makes a note of why the thread had to wait and this is called the wait type.

Servers 40

Servers Azure Metrics Tuning 40

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