SQL Performance

MAY 16, 2019

If both sort and no-sort alternatives are available, the optimizer will make a cost-based choice. The following script should be run on a development SQL Server instance in a new test database set to use the SIMPLE or BULK_LOGGED recovery model. spt_values AS SV ; Plan Caching. DECLARE @NumRows bigint = 269 ; INSERT dbo.

Cache 67

Cache Servers Testing Storage 67

Adrian Cockcroft

JANUARY 29, 2023

A later version of the slides is included in my Microservices Workshop deck from later that year, slides 168–200 ( pdf , keynote are available in GitHub.com/adrianco/slides ). For this demo on an old MacBook (2.7 I presented this analysis of response time distributions talk in 2016 — at Microxchg in Berlin ( video ).

Lambda 98

Lambda Latency Cache C++ 98

Dynatrace

SEPTEMBER 17, 2019

Instead of presenting you with a handful of random screenshots from our demo environment I reached out to Robert, a close friend of mine, who leads a development team with the current task to re-architect and re-platform their multi-tenant SaaS-based eCommerce platform. REDIS for caching. NGINX as an API Gateway.

AWS 127

AWS Monitoring Ecommerce Lambda 127

Smashing Magazine

JANUARY 6, 2020

Usually, the most specific and relevant ones are: Time to Interactive (TTI) The point at which layout has stabilized, key webfonts are visible, and the main thread is available enough to handle user input — basically the time mark when a user can interact with the UI. Getting started with Webpack can be tough though.

Performance 145

Performance Cache Network Metrics 145

SQL Performance

MAY 29, 2019

The script below is a modification of the demo used in earlier parts in this series. The test table schema is such that 130 rows can fit on a single 8KB page when row versioning is off for the database. GO. -- Clear the plan cache. The modified demo script is: IF OBJECT_ID ( N'dbo.Test' , N'U' ) IS NOT NULL.

Cache 64

Cache Testing Servers Code 64

SQL Performance

JUNE 5, 2019

Neither is ideal, and when you simply have too many queries asking for more memory than is available to grant, you’ll see RESOURCE_SEMAPHORE waits. We will restore the backup and enable Query Store, and clear out any old Query Store data so we do not alter any metrics for this demo. USE [ master ] ; GO. ) ; GO.

Servers 41

Servers Cache Database Metrics 41

Smashing Magazine

JANUARY 7, 2019

Time to Interactive (TTI) The point at which layout has stabilized, key webfonts are visible, and the main thread is available enough to handle user input — basically the time mark when a user can interact with the UI. Long FMP usually indicates JavaScript blocking the main thread, but could be related to back-end/server issues as well.

Performance 103

Performance Cache Metrics Network 103

Percona

JANUARY 4, 2023

Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. You can locate all instruments available in your MySQL version under table setup_instruments. For getting familiar, check the PMM demo. We started looking into the stats of the performance schema.

Performance 98

Performance C++ Monitoring Servers 98

Smashing Magazine

JANUARY 21, 2019

Following, the API will add the database object data. This information is not placed under each module, but under a shared section called databases , to avoid duplicating information when two or more different modules fetch the same objects from the database. In other words, database object data is normalized.

Social Media 64

Social Media Database Media Website 64

SQL Performance

MARCH 8, 2021

The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo. Total elapsed time is 933ms with 6,673ms of CPU time with a warm cache. The yellow consumer times are short because it is quick to retrieve a row from the exchange when data is available.

Servers 95

Servers Tuning Architecture Processing 95