Remove 2017 Remove Cache Remove Software Engineering Remove Storage
article thumbnail

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

SQL Server According to Bob

Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be Microsoft SQL Server Database Engine Input/Output Requirements. Description.

Servers 90
article thumbnail

SQL Server on IoT Edge and Developer Machines – Smaller Footprint

SQL Server According to Bob

For example, Azure SQL Database Edge can already use TSQL Predict Machine Learning (ML) and Column Storage. The reduction effort started when we shipped SQL Server 2017 ( [link].) The lock manager has partitions, lock block cache and other structures. Reduce the number of partitions and size of the cache. SQL Server 2017.

IoT 61
article thumbnail

Viewing and Sorting XEvents Efficiently (Code Samples) – XEProfiler

SQL Server According to Bob

Using SQL Server Management Studio (SSMS) and storing the events in a table requires reading the events, streaming to table storage followed by an order by event sequence query. Bob Dorr – Principal Software Engineer SQL Server. Large traces can encounter the 32-bit SSMS memory limitations.