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.
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. “. 4 Socket, TPCC.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
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. Back-end servers. Don't blame the straw, in this case, don't blame the frame pointers.
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 Performance
MARCH 22, 2022
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. The aim is to reduce compilations by increasing cached plan reuse. Simple Parameterization. Shell Plans.
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.
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.
40 
Let's personalize your content