Remove 2005 Remove Cache Remove Code Remove Performance
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. I'm sure this delivered large performance improvements and I wouldn't try arguing against it. This is exactly what happened on Linux, not just /usr/bin but also /usr/lib and application code!

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

Simple Parameterization and Trivial Plans — Part 1

SQL Performance

Both target performance and efficiency for workloads frequently submitting simple statements. 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. Simple Parameterization. Shell Plans.

Cache 61
article thumbnail

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

John McCalpin

This was a keynote presentation at the “2nd International Workshop on Performance Modeling: Methods and Applications” (PMMA16), June 23, 2016, Frankfurt, Germany (in conjunction with ISC16 ). Here I assumed a particular analytical function for the amount of memory traffic as a function of cache size to scale the bandwidth time.

article thumbnail

How to Avoid Vendor Lock In

IO River

CloudFront makes a simple choice here as it offers direct integration with all these services to let you cache responses across its global edge locations. ‍You might keep introducing CDN-level features specific to CloudFront that significantly improve your application's performance.

Lambda 52
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 to Avoid Vendor Lock In

IO River

CloudFront makes a simple choice here as it offers direct integration with all these services to let you cache responses across its global edge locations. You might keep introducing CDN-level features specific to CloudFront that significantly improve your application's performance.

Lambda 52