Brendan Gregg
MARCH 16, 2024
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.
SQL Performance
MARCH 29, 2022
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.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
ScaleOut Software
JUNE 22, 2020
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.
ScaleOut Software
JUNE 22, 2020
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.
SQL Performance
MARCH 22, 2022
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.
SQL Performance
MARCH 30, 2021
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. (
All Things Distributed
SEPTEMBER 20, 2013
Not everybody agreed that the "N-ary Storage Model" (NSM) was the best approach for all workloads but it stayed dominant until hardware constraints, especially on caches, forced the community to revisit some of the alternatives. The first practical modern implementation is probably C-Store by Stonebraker, et al.
Expert insights. Personalized for you.
137 
Let's personalize your content