Remove 2005 Remove Availability Remove Cache Remove Hardware
article thumbnail

The Return of the Frame Pointers

Brendan Gregg

This technique saves two instructions in the prologue and epilogue and makes one additional general-purpose register (%rbp) available." 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.

Java 145
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

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system. FILE_FLAG_NO_BUFFERING is the Win32, CreateFile API flags and attributes setting to bypass file system cache. FILE_FLAG_NO_BUFFERING is the Win32, CreateFile API flags and attributes setting to bypass file system cache.

Servers 90