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.
Dean Hume
APRIL 24, 2018
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!
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Dean Hume
APRIL 24, 2018
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!
Dean Hume
APRIL 24, 2018
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!
Brendan Gregg
MARCH 16, 2024
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.
SQL Server According to Bob
DECEMBER 18, 2018
Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system. Before all was said and done, all of these people and more helped with various activities: · Eugene, Mike, Slava, Scott, Peter, Steve and others doing code reviews on my SQL Server and Host Extension changes. ·
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. 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.
Expert insights. Personalized for you.
90 
Let's personalize your content