article thumbnail

Simple Parameterization and Trivial Plans — Part 2

SQL Performance

Simple parameterization has a number of quirks in this area, which can result in more parameterized plans being cached than expected, or finding different results compared with the unparameterized version. For the time being, let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14. DisplayName.

Cache 90
article thumbnail

Analyzing a High Rate of Paging

Brendan Gregg

Reads usually have apps waiting on them; writes may not (write-back caching). total used free shared buff/cache available Mem: 64414 15421 349 5 48643 48409 Swap: 0 0 0. There's not much memory left, 349 Mbytes, but more interesting is the amount in the buffer/page cache: 48,643 Mbytes (48 Gbytes). Counting cache functions.

Cache 105
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

AB Testing?—?So You Know What Really Works

Adrian Cockcroft

AB Testing?—?So The first thing I found was that every user visible change we made went through an A/B test. An oft-quoted study by Microsoft Bing found that of the changes they test, one-third prove effective, one-third have neutral results, and one-third have negative results. So You Know What Really Works ??Castillo

Testing 52
article thumbnail

A New Way To Reduce Font Loading Impact: CSS Font Descriptors

Smashing Magazine

A number of sites moved to font-display: swap when this first came out, and Google Fonts even made it the default in 2019. It’s also trickier to handle cached fonts we already have, not to mention differences in various fallback styles. However, beyond that it didn’t really solve the problem.

article thumbnail

If You’re Not Lazy Loading Your Images, You’re Being Wasteful

MachMetrics

It’s now almost 2019, and there are no more excuses. Now let’s upload our lazy-loading updates and try again: (Note that you’ll have to do hard-reload, clear cache, or use a new private browser to ensure we’re not taking advantage of the browser cache in our testing).

Cache 75
article thumbnail

Analyzing a High Rate of Paging

Brendan Gregg

Reads usually have apps waiting on them; writes may not (write-back caching). This is a 64-Gbyte memory system, and 48 Gbytes is in the page cache (the file system cache). Along with the numbers from the problem statement, this gives me a theory: Do the 100-Gbyte files bust the page cache, whereas 40-Gbyte files fit?

Cache 40
article thumbnail

MICRO 2019 Trip Report

ACM Sigarch

Two Test of Time awards went to: “Speculative Lock Elision: Enabling Highly Concurrent Multithreaded Execution” published at MICRO 2001 by Ravi Rajwar and James R. Goodman, and “Speculative Cache Ways: On-Demand Cache Resource Allocation” published at MICRO 1999 by David H.