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.

Servers 40

Servers Cache Database Media 40

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. “. The Back Story.

Servers 90

Servers Media Cache Storage 90

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.

Cache 98

Cache Servers Operating System Processing 98

Brendan Gregg

AUGUST 8, 2017

Nowadays, the source code to old operating systems can also be found online. For everyone familiar with other operating systems and their CPU load averages, including this state is at first deeply confusing. **Why?** The oldest change in the entire Linux repo dates back to 2005, when Linus imported Linux 2.6.12-rc2,

Latency 111

Latency Metrics C++ Systems 111