Remove 2016 Remove Azure Remove Cache Remove Operating System
article thumbnail

Common SQL Server Mishaps

SQL Performance

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. Azure SQL Database and Azure Managed Instance have managed backups. This issue is valid for on-premises, IaaS, and partially for Azure SQL Managed Instance. Statistics.

Servers 49
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. The “forced flush” changes in SQL Server avoid flushes, when possible, in order to improve performance on non-optimized Fua file systems. Linux open command flag used to bypass file system cache.

Servers 90