SQL Performance

JUNE 10, 2020

This month and the next I’m going to cover the physical processing aspects of derived tables. That is, does SQL Server perform a substitution process whereby it converts the original nested code into one query that goes directly against the base tables? And if so, is there a way to instruct SQL Server to avoid this unnesting process?

C++ 109

C++ Database Servers Code 109

HammerDB

APRIL 19, 2023

Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. In the context of MySQL performance evaluation, it simulates a typical online transaction processing (OLTP) workload on your MySQL database. and 8.0.32 HammerDB 4.5 Concurrency at 80 VU’s 1.00

Performance 54

Performance Benchmarking Cache Storage 54

ScaleOut Software

AUGUST 20, 2020

Simplifying the Development Process with Mock Environments. The key to meeting these challenges is to process incoming telemetry in the context of unique state information maintained for each individual data source. They make use of standard object-oriented concepts and languages (such as C#, Java, and JavaScript).

Cloud 52

Cloud Development Analytics Azure 52

ScaleOut Software

AUGUST 20, 2020

Simplifying the Development Process with Mock Environments. The key to meeting these challenges is to process incoming telemetry in the context of unique state information maintained for each individual data source. They make use of standard object-oriented concepts and languages (such as C#, Java, and JavaScript).

Cloud 52

Cloud Development Analytics Azure 52

Tasktop

FEBRUARY 1, 2021

In a project organization, this flow is spread across teams, functions, tools, processes and even external parties like vendors. Carving out the relevant pieces for each product is an iterative process. The more this process encroaches on the status quo, the more resistance you will encounter. . Measuring the Flow.

Logistics 52

Logistics Metrics Architecture Software 52

SQL Performance

JUNE 10, 2020

This month and the next I’m going to cover the physical processing aspects of derived tables. That is, does SQL Server perform a substitution process whereby it converts the original nested code into one query that goes directly against the base tables? And if so, is there a way to instruct SQL Server to avoid this unnesting process?

C++ 93

C++ Database Servers Code 93

The Agile Manager

NOVEMBER 30, 2020

These can be useful exercises, certainly to the business leaders who’ve got to find their customers or compete against rivals with slimmed down cost structures. Or, suppose that city C imposes putative taxes on companies employing a distributed workforce. It’s not unprecedented.

Airlines 52

Airlines Retail C++ Transportation 52

Tasktop

OCTOBER 29, 2020

Beneath the question lies a fear — always legitimate, but especially so in a year of economic distress and highly constrained budgets — that a VSM tool will simply expose what is already known: “Our processes, workflows and tools are a mess. After we’ve cleaned up our act and matured our processes, we’ll finally be ready for a VSM tool.” .

Storage 52

Storage Speed C++ DevOps 52

The Agile Manager

AUGUST 31, 2021

If we accept the fact that Agile is a value system and not a set of mechanical processes, it stands to reason that there must be something different about the norms and behaviors of Agile managers vis-a-vis traditional managers. Create and adapt the mechanical processes and social systems through which the team gets things done.

Metrics 52

Metrics Design Engineering C++ 52

Nick Desaulniers

APRIL 18, 2014

So a whole Babel of computer languages has been created for programmers: FORTRAN, BASIC, COBOL, LISP, Pascal, C, PROLOG, FORTH. This blog is meant for those who don’t know x86-64 assembly, but maybe know a little C, and are curious about code generation. But you never can tell exactly what the compiler is doing. Dan Gohman.

C++ 98

C++ Programming Code Virtualization 98

SQL Server According to Bob

FEBRUARY 10, 2019

– -c the control file. I started with a cmd file script exercising the connection path. If the login was in the middle of processing pre-login the ring buffer entry may show time spent in SSL, reads, etc and the disconnect. · The dump suspends the SQL Server process. – -n controls the number of threads.

Servers 40

Servers Network Database Systems 40

Speed Curve

MARCH 5, 2023

Site A Site B Site C Site D Observations 1. The poverty line emerges surprisingly quickly in some cases For example, Site C's performance poverty line starts at 400 milliseconds. For some sites (such as Site C), the difference was as little as 300 milliseconds. That's early! You need to look at your own real user data. (If

Performance 119

Performance C++ Metrics Ecommerce 119

Percona

DECEMBER 5, 2023

The scenario Service considerations In this exercise, we wanted to perform a major version upgrade from PostgreSQL v12.16 While we’ve contemplated taking a physical backup and conducting PITR , it’s worth noting that PITR can also be executed on the existing replica or delayed replica to expedite the process. and a v15.4.

Database 74

Database Traffic C++ Servers 74

CSS Wizardry

NOVEMBER 3, 2020

The whole point of the exercise that follows is to allow me to move quickly, spotting patterns from afar, and not having to do any slow or meticulous work yet. Of course, it’s a little more complex than that, but for this exercise it’s an incredibly reliable proxy. This is basically how many render blocking resources each page has.

Speed 292

Speed Ecommerce Metrics Analytics 292

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. A change to such parameters requires the postmaster — the main process of the PostgreSQL — to restart. psql "host=localhost user=postgres options='-c synchronous_commit=off'" psql (14.8)

Database 99

Database Servers Open Source Tuning 99

The Agile Manager

APRIL 26, 2010

A leaned-out IT organization capitalizing a significant proportion of its discretionary spend is highly susceptible to a perfect storm of (a) SG&A contraction, (b) IT project write-off, and (c) suspended IT investments. Capitalizing development of IT assets is an exercise in funding salaries and contractor costs out of CapEx budgets.

Government 49

Government Efficiency C++ Software 49

Speed Curve

MARCH 5, 2023

Site A Site B Site C Site D Observations 1. The plateau emerges surprisingly quickly in some cases For example, Site C's performance plateau starts at 400 milliseconds. For some sites (such as Site C), the difference was as little as 300 milliseconds. That's early! You need to look at your own real user data. (If

Performance 52

Performance C++ Metrics Ecommerce 52

SQL Performance

APRIL 14, 2021

Evaluating earlier solutions, one of the important factors in getting good performance was the ability to employ batch processing. Let’s examine the plans for two of the earlier solutions that utilized batch processing. But have we exploited it to the maximum extent possible?

C++ 112

C++ Servers Testing Code 112

HammerDB

JULY 16, 2021

with the TPROC-C workload on a system with 2 sockets of Intel Xeon 8280L that means we have 28 cores per socket, with 56 physical CPUs and 112 logical CPUs with Hyper-Threading. Plotting these data points enables us to understand the scalability of the database software being tested on that system. and MySQL 8.0.25 and MySQL 8.0.25

Virtualization 57

Virtualization Performance C++ Database 57

The Morning Paper

DECEMBER 8, 2019

The eagle-eyed reader will have noticed another feature of this work in that quotation: the aim is to create a global address space that spans nodes and processes. The Twizzler KVS (key-value store) is just 250 lines of C code, and uses one persistent object for the index structure, and a second one for the data. What about security?

Hardware 56

Hardware Programming Media Storage 56

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

All Things Distributed

NOVEMBER 15, 2010

From financial processing and traditional oil & gas exploration HPC applications to integrating complex 3D graphics into online and mobile applications, the applications of GPU processing appear to be limitless. Because of its focus on latency, the generic CPU yielded rather inefficient system for graphics processing.

AWS 136

AWS Latency Programming Architecture 136