2005 Cache Performance Servers 
Brendan Gregg
MARCH 16, 2024
I'm sure this delivered large performance improvements and I wouldn't try arguing against it. 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
JANUARY 11, 2020
Microsoft, Windows, Windows NT, and Windows Server are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
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. When SQL Server applies simple parameterization to an ad-hoc statement, it makes a guess about the data type of the replacement parameter.
SQL Server According to Bob
DECEMBER 18, 2018
SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.
SQL Performance
MARCH 30, 2021
This five-part series takes a deep dive into the way SQL Server row mode parallel plans start up. It includes initializing each operator, and adding hidden profilers to collect runtime performance data like actual row count and elapsed time. See Myth: SQL Server Caches a Serial Plan with every Parallel Plan for details.
SQL Performance
MARCH 22, 2022
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. It's almost always better to explicitly parameterize statements, rather than relying on the server to do it. Users AS U.
ScaleOut Software
JUNE 22, 2020
From Distributed Caches to Real-Time Digital Twins. The pace of these changes has made it challenging for server-based infrastructures to manage fast-growing populations of users and data sources while maintaining fast response times.
Expert insights. Personalized for you.
145 
Let's personalize your content