SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.” – [link]. Starting with the Linux 4.18

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

MAY 19, 2019

The reduction effort started when we shipped SQL Server 2017 ( [link].) Partitioning allows SQL Server to scale to the largest systems with record-setting performance. When promoted to a super-latch on a 64 CPU system the memory requirement becomes 32 + (32 *64) = 2080 bytes. IO Request Caches. SQL Server 2017.

IoT 61

IoT Servers Development Cache 61

SQL Server According to Bob

DECEMBER 18, 2018

This means data can be stored in file system cache, non-stable media. ) The issue, as described in the link, is that the sync returns the error but may clear the state of the cached pages. Assume the database application opens the backup file, allowing file system caching (~_O_DIRECT.) reporting an EIO error.

Servers 40

Servers Media Cache Software Engineering 40

SQL Server According to Bob

DECEMBER 31, 2018

iBytesRead = s.Read(bData, 0, c_iMaxReadSize); } }. . // Do we need to start the read-ahead to suck data into file system cache if (iCookie > -1) { tReadAhead.Start(iCookie); } }. Bob Dorr – Principal Software Engineer SQL Server. CREATE EVENT SESSION [EventSequence] ON SERVER ADD EVENT sqlserver.

Efficiency 40

Efficiency Code Servers Cache 40