Remove 2016 Remove Blog Remove Cache Remove Operating System
article thumbnail

How It Works (It Just Runs Faster): Non-Volatile Memory SQL Server Tail Of Log Caching on NVDIMM

SQL Server According to Bob

Note: We received feedback that there was some confusion on us calling this functionality “tail of the log caching” because our documentation and prior history has referred to the tail of the log as the portion of the hardened log that has not been backed up. Tail Of Log Caching. Announcement and Syntax Example: [link]. .

Cache 40
article thumbnail

Common SQL Server Mishaps

SQL Performance

I wrote a blog about it years ago too, however as time has marched on, guidance has changed a bit. Prior to SQL Server 2012, the maximum server memory value only applied to the bufferpool, so customers needed to limit the amount of memory the bufferpool could use to save memory for the operating system and other processes.

Servers 49
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

MariaDB vs MySQL: Key Differences and Use Cases

Percona

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). It supports multiple operating systems and platforms, making it an ideal choice for various applications. What is MySQL?

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
article thumbnail

How Improving Website Performance Can Help Save The Planet

Smashing Magazine

For the more adventurous/technical, the top (table of processes) command provides similar metrics on most Unix-like operating systems such as macOS and Ubuntu. In 2016, O’Reilly published “ Designing For Sustainability ” by Tim Frick. A particular favorite in the WordPress space is WP Super Cache.