Remove 2005 Remove Cache Remove Code
article thumbnail

The Return of the Frame Pointers

Brendan Gregg

Apart from library code, maybe your application doesn't have frame pointers either, in which case everything is broken. 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.

Java 137
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.

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. Still, you should write code with both close to the front of your mind. For legacy applications or other third-party code that cannot be easily changed, explicit parameterization may not always be possible.

Cache 61
article thumbnail

The Surprising Effectiveness of Non-Overlapping, Sensitivity-Based Performance Models

John McCalpin

The presentation discusses a family of simple performance models that I developed over the last 20 years — originally in support of processor and system design at SGI (1996-1999), IBM (1999-2005), and AMD (2006-2008), but more recently in support of system procurements at The Texas Advanced Computing Center (TACC) (2009-present).

article thumbnail

Service Workers can save the environment!

Dean Hume

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Without effective caching on the client, the server will see an increase in workload, more CPU usage and ultimately increased latency for the end user. Show me the money!

Energy 40
article thumbnail

Service Workers can save the environment!

Dean Hume

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Without effective caching on the client, the server will see an increase in workload, more CPU usage and ultimately increased latency for the end user. Show me the money!

Energy 40
article thumbnail

Service Workers can save the environment!

Dean Hume

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Without effective caching on the client, the server will see an increase in workload, more CPU usage and ultimately increased latency for the end user. Show me the money!

Energy 40