article thumbnail

The Return of the Frame Pointers

Brendan Gregg

2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth. It shouldn't be 10%, unless it's cache effects. And for leaf routines (which never establish a frame), this is a non-issue.

Java 145
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. Reputation = 252552 ; These statements result in six cached plans, three Adhoc and three Prepared : Different guessed types.

Cache 90
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

The Amazing Evolution of In-Memory Computing

ScaleOut Software

From Distributed Caches to Real-Time Digital Twins. Emerging in the early 2000s, the first such platforms provided distributed caching on clustered servers with straightforward APIs for storing and retrieving in-memory objects.

article thumbnail

The Amazing Evolution of In-Memory Computing

ScaleOut Software

From Distributed Caches to Real-Time Digital Twins. Emerging in the early 2000s, the first such platforms provided distributed caching on clustered servers with straightforward APIs for storing and retrieving in-memory objects.

article thumbnail

Simple Parameterization and Trivial Plans — Part 1

SQL Performance

In this first part, after a quick introduction, I look at the effects of simple parameterization on the plan cache. When SQL Server 2005 introduced Forced Parameterization , the existing auto-parameterization feature was renamed to Simple Parameterization. The aim is to reduce compilations by increasing cached plan reuse.

Cache 61
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

As ​​ the ​​ administrator of a SQL Server 2005 installation, ​​ you will find that ​​ visibility into ​​ the ​​ SQL Server ​​ I/O ​​ subsystem ​​ has been ​​ significantly increased.

Servers 40
article thumbnail

How Parallel Plans Start Up – Part 1

SQL Performance

The fundamentals of row mode parallel execution haven’t changed since SQL Server 2005, so the following discussion is broadly applicable. Running a parallel plan on a single thread can also happen when a cached parallel plan is reused by a session that is limited to DOP 1 by an environmental setting (e.g. MonthlyPosts AS. (

Cache 98