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. A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions.

C++ 58

C++ Database Servers Storage 58

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. The first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). The question went something like this….

Servers 40

Servers Database Azure Cache 40

Dynatrace

OCTOBER 28, 2021

As software performance degrades or fails, the chaos engineers’ findings enable developers to add resiliency into the code, so the application remains intact in an emergency. Chaos engineering matured at organizations such as Netflix, and gave rise to technologies such as Gremlin (2016) , becoming more targeted and knowledge-based.

Engineering 221

Engineering Entertainment Cloud Infrastructure 221

SQL Performance

MARCH 15, 2021

This time around, I want to talk about a feature included with SQL Server client tools that we should not be using these days – not just because it is deprecated but, more importantly, because it has the potential to completely take a server down: SQL Server Profiler. Not too long ago, something like this happened to us.

Servers 64

Servers Azure Best Practices Monitoring 64

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. Individual processes generate WAL records, and latency is very crucial for transactions. So it has never been part of the general advice for optimizations.

Database 118

Database Benchmarking Open Source Latency 118

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process.

Open Source 52

Open Source Servers Storage Scalability 52

SQL Server According to Bob

FEBRUARY 10, 2019

. · Failures occur from remote clients or sqlcmd executed directory on the server (/opt/mssql-tools/bin). SQL Server 2017 CU10 does not show behavior. · SQL Server 2017 CU12 exhibits the behavior. Server is a Superdome with lots of CPUs and RAM. Here is an example of a valid SQL Server login. – sqlclr.

Servers 40

Servers Network Database Systems 40

Brendan Gregg

OCTOBER 8, 2018

Some one-liners: # New processes with arguments bpftrace -e 'tracepoint:syscalls:sys_enter_execve { join(args->argv); }'. Files opened by process bpftrace -e 'tracepoint:syscalls:sys_enter_open { printf("%s %sn", comm, str(args->filename)); }'. Pages paged in by process bpftrace -e 'software:major-faults:1 { @[comm] = count(); }'.

C++ 110

C++ Virtualization Programming Latency 110

SQL Server According to Bob

APRIL 25, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. 10 percent processed.

Servers 40

Servers Database Processing Virtualization 40

SQL Server According to Bob

APRIL 21, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. 10 percent processed.

Servers 40

Servers Database Processing Virtualization 40

SQL Performance

AUGUST 14, 2019

Run the following code to create the Transactions table and populate it with sample data: SET NOCOUNT ON ; USE TSQLV5 ; -- [link]. The performance penalty is relevant only when the window function is optimized with row-mode processing operators. Transactions ; The plan for this query, using row-mode processing, is shown in Figure 1.

Best Practices 108

Best Practices Servers Database Azure 108

SQL Performance

APRIL 20, 2021

This is the third in a five-part series taking a deep dive into the way SQL Server row mode parallel plans start executing. We are now ready to start the query scan, perform some early phase processing, and start the first additional parallel tasks. SQL Server could have been designed to start all the extra parallel bits all at once.

C++ 98

C++ Processing Servers Cache 98

SQL Performance

DECEMBER 9, 2020

I mainly experimented with different table value constructor cardinalities, with serial versus parallel processing, and with row mode versus batch mode processing. Use the following code to run a test with base CTE cardinality of 2 (requires 5 additional levels of CTEs): DECLARE @low AS BIGINT = 1 , @high AS BIGINT = 100000000 ; WITH.

C++ 61

C++ Servers Testing Processing 61

SQL Performance

JUNE 9, 2021

Note that the CREATE OR ALTER part was introduced in SQL Server 2016 SP1, so if you’re using an earlier version, you will need to work with separate CREATE VIEW and ALTER VIEW statements depending on whether the object already exists or not. You already saw the code with derived tables and CTEs earlier in the series. OrderYears.

Database 140

Database Code Design Development 140

Alex Podelko

OCTOBER 28, 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. To do this, the tool should have the ability to add code to (or invoke code from) your script. – Cloud. – Agile.

Performance Testing 100

Performance Testing Technology Technology Testing 100

SQL Server According to Bob

JANUARY 28, 2018

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). The application then uses the SQL Server client (SQL Server ODBC for this example) to establish a TDS based connection to the target SQL Server (local or remote.). Local Host Name. The olehlp!

Servers 40

Servers Azure Engineering Java 40

CSS - Tricks

APRIL 1, 2021

The code for the site is available on GitHub for reference. This is the process of turning HTML, CSS and JavaScript into a fully fleshed out, interactive website. It begins with retrieving the HTML from the server and converting this into the Document Object Model (DOM). The CSSOM and the DOM combine to make the render tree.

Cache 92

Cache Social Media Media Website 92

Brendan Gregg

SEPTEMBER 5, 2017

LTS (April 2016). It uses a Solaris Porting Layer (SPL) to provide a Solaris-kernel interface on Linux, so that unmodified ZFS code can execute. There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process).

Virtualization 76

Virtualization AWS Engineering Hardware 76

Enprowess

SEPTEMBER 28, 2021

React developers introduced Inferno in 2016 as an experiment to examine whether or not a library can improve the battery, performance, and UX of mobile apps. Inferno JS would be your best option, if you would like to build client and server-side interfaces with faster speeds, better performance, and isomorphic rendering. .

Open Source 52

Open Source Mobile Entertainment Virtualization 52

SQL Performance

APRIL 23, 2019

In SQL Server 2012, grouped (vector) aggregation was able to use parallel batch-mode execution, but only for the partial (per-thread) aggregate. SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. Introduction. instructions are available.

Servers 67

Servers Testing Metrics Storage 67

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

SEPTEMBER 5, 2019

I briefly mentioned that batch mode data is normalized in my last article Batch Mode Bitmaps in SQL Server. You will need SQL Server 2016 (or later) and Developer Edition (or equivalent) to reproduce the results shown here. You can skip the WHERE clauses if you are running SQL Server 2017. Why the difference?

Performance 81

Performance C++ Storage Servers 81

SQL Performance

SEPTEMBER 25, 2019

You can read more details about the process in my Query Optimizer Deep Dive series. For modern versions of SQL Server, this essentially means that all key columns in an index spool must be of a comparable type, no more than 900 bytes* in total, with 64 key columns or fewer. As part of that process, an estimated cost is calculated.

Performance 104

Performance Cache Servers Education 104

Smashing Magazine

JANUARY 15, 2019

So, apart from powering servers with renewable energy, what else can web developers do about climate change? This includes the work done by the server, the client and the intermediary communications networks that transmit data between the two. In 2016, O’Reilly published “ Designing For Sustainability ” by Tim Frick.

Website Performance 73

Website Performance Website Energy Performance 73

Brendan Gregg

OCTOBER 7, 2018

Some one-liners: # New processes with arguments bpftrace -e 'tracepoint:syscalls:sys_enter_execve { join(args->argv); }'. Files opened by process bpftrace -e 'tracepoint:syscalls:sys_enter_open { printf("%s %sn", comm, str(args->filename)); }'. Pages paged in by process bpftrace -e 'software:major-faults:1 { @[comm] = count(); }'.

C++ 40

C++ Virtualization Programming Latency 40

SQL Performance

JULY 9, 2019

The ISO/IEC 9075:2016 standard (SQL:2016) defines a feature called nested window functions. I posted a suggestion to improve SQL Server by adding support for nested window functions. This feature allows you to nest two kinds of window functions as an argument of a window aggregate function.

Servers 83

Servers Availability Database Code 83

Alex Russell

MARCH 31, 2022

Browsers are unable to rely on semantic versioning or trust file names because returned resources must contain the exact code that developers request. Late in the drafting of this post, it was pointed out to me by Frederik Braun that Brad Hill had considered the downsides of a site-populated SRI addressable cache back in 2016.

Cache 82

Cache Government Traffic Network 82

Alex Russell

OCTOBER 22, 2017

Answering it requires an understanding of how browsers process resources (which differs by type) and the concept of the critical path. Late-loading JavaScript can cause “server-side rendered” pages to fail in infuriating ways. This input processing happens on document’s main thread , where JavaScript runs.

Performance 68

Performance Benchmarking Network Mobile 68

Rigor

SEPTEMBER 11, 2019

Reading time 16 min Whether you’re a web performance expert, an evangelist for the culture of performance, a web engineer incorporating performance into your process, or someone new to the web performance entirely, you probably identify as curious, excited about new ideas, and always learning. The future of HTTP/2 server push.

Performance 89

Performance Education Google Website 89

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. Now we have a problem statement that we can reason about: why are large chunks of our code segment filled with zeroes?

Programming 79

Programming Hardware Cache Code 79

Alex Russell

MAY 9, 2022

Effective managers understand that products require processes to manage, yet front-end discourse assumes that switching frameworks will introduce a golden age. Who owns this code? When sibling teams are brought in to integrate late in the process, attention to the cumulative experience may suffer. Why is it there?

Performance 86

Performance Latency Metrics Engineering 86

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. Servers down or server health issues [APM]. Response code or issues with the rendered page [Synthetic]. Traffic patterns outside of normal [RUM or Analytics].

Website 74

Website Cache Ecommerce Traffic 74

Smashing Magazine

JUNE 26, 2019

Clean coding practices. After all, Opens Sans is a Google Font that has to be served from Google’s servers. They might not be as exciting to design with, but they won’t force users to sit around and wait for your website to load, costing you visitors and customers in the process. Minification. Image optimization. Backup plugins.

Website 110

Website Speed Mobile Design 110

Smashing Magazine

OCTOBER 26, 2018

Because of its history and for being sort of a fork of an old blogging platform called “b2” (more details here ), it’s largely written in a procedural way (using function-based code). Recommended reading : WordPress Security As A Process. Before we delve deeper in the code, a couple more things about WordPress REST API.

Cache 78

Cache Website Speed Database 78

The Symphonia

DECEMBER 6, 2017

Specific improvements include A new code editor for those who write their Lambda functions in Javascript and Python, far superior to the old inline code-editor. We don’t recommend using this as a regular process for production use, but it might come in handy at development time. without web app servers?—?to

Serverless 40

Serverless Lambda AWS Traffic 40

Alex Russell

FEBRUARY 3, 2023

Partisans for slow, complex frameworks have successfully marketed lemons as the hot new thing, despite the pervasive failures in their wake, and crowding out higher-quality options in the process. [1] "Server-Side Rendering", a.k.a. "SSR" " [ an intro to "isomorphic javascript", a.k.a. "Server-Side

Social Media 119

Social Media Website Technology Technology 119

All Things Distributed

DECEMBER 13, 2016

In just this past month we've had HSBC , ARM , Missguided , and most recently at re:Invent 2016 , Trainline , talking with us about how they are using AWS to transform and scale their businesses. Take GoSquared , a UK startup that runs all its development and production processes on AWS, as an example.

AWS 166

AWS Cloud Artificial Intelligence IoT 166