SQL Performance

OCTOBER 20, 2022

Test 5—Lock escalation reading data. Replace the test statement in the procedure from part one with the following: -- Test statement(s). OPTION ( MAXDOP 1 ) ; -- End test statement(s). All the tests in this part are run under locking read committed isolation. Test 6—No escalation on a heap.

Testing 91

Testing Servers Cache Engineering 91

Sutter's Mill

JANUARY 25, 2021

Not only is the integer comparison operation cheap, but min and max are already being accessed by this function and so they’re already “hot” in registers or cache. That’s true whether we’re enabling checking at test time (e.g., Some conditions are so expensive that we may never check them without a good reason, even in testing.

C++ 45

C++ Programming Cache Testing 45

The Morning Paper

SEPTEMBER 24, 2019

There are four main parts to the story here: The testing environment that runs apps in a ‘honeypot’ and figures out which of those apps are leaking data they don’t have permission to obtain. The test mobile phones run an instrumented version of Android Marshmallow, on top of a custom Linux kernel which records all file I/O.

Systems 74

Systems Traffic Network Google 74

SQL Server According to Bob

JANUARY 26, 2017

Quick question about a behavior we’re seeing at a customer and in testing. Note: Be sure to set your ‘max server memory’ back to 0 when you are done with this fun exercise. c:public_symbols is a symbol cache and a folder I created on my laptop. In my test I did not hit the breakpoint. The –y parameter is the symbol path.

Servers 40

Servers Database Azure Cache 40

Dynatrace

APRIL 21, 2022

Once you have and understand this data, you can identify issues, find opportunities for improvement, and eliminate risks before you go through a costly migration exercise. Missing caching layers. To make an informed decision on what to optimize within your application, you must first collect baseline performance data.

Azure 188

Azure Monitoring Virtualization Metrics 188

The Morning Paper

JANUARY 23, 2020

The process tracing exercise included: Examning IRC transcripts from multiple channels. Peer consensus was the primary mechanism used to decide whether to take actions affecting the production systems, and on two occassions changes were pushed through without waiting for automated tests to complete. " – wikipedia.

Internet 53

Internet Internet Cache Engineering 53

Brendan Gregg

JUNE 30, 2018

sounds like a homework exercise of purely academic value. This is a sanity test. In some cases, a benchmark may appear to exceed network bandwidth because it returns from a local memory cache instead of the remote target. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec? What's the limiter?"

Benchmarking 54

Benchmarking Latency Cache Network 54

Percona

JULY 6, 2023

then true else false end FROM generate_series(1, 10000000); Now we have our test table with some dummy data so we can practice. then true else false end FROM generate_series(1, 10000000); Now we have our test table with some dummy data so we can practice. Next is the table definition.

Best Practices 89

Best Practices Tuning Database Testing 89

Brendan Gregg

JUNE 29, 2018

sounds like a homework exercise of purely academic value. This is a sanity test. In some cases, a benchmark may appear to exceed network bandwidth because it returns from a local memory cache instead of the remote target. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec? What's the limiter?"

Benchmarking 40

Benchmarking Latency Cache Network 40

The Netflix TechBlog

MARCH 6, 2019

Disk Caching? — ? MezzFS can be configured to cache objects on the local disk. Regional caching? —?Netflix If an application in region A is using MezzFS to read from an object stored in region B, MezzFS will cache the object in region A. we only pay the transfer costs for one worker, and the rest use the cached object.

Media 214

Media Storage Processing Cache 214