Percona

AUGUST 29, 2018

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are configured according to the database server and its workload.

Tuning 59

Tuning Database Servers Processing 59

SQL Server According to Bob

JANUARY 31, 2017

On Linux the total number of buffers that can be read or written, in a single ABI request, is capped at 2048. The buffers must be the operating system page size (4K.) There are a few locations (zero file, column store, …) in SQL Server which attempt to read or write more then 1024 database pages in a single request.

Servers 40

Servers Software Engineering Operating System Database 40

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? ​​ SQL Server ​​ copy-on-write actions are used to maintain snapshot databases in SQL Server 2005.

Servers 40

Servers Cache Database Media 40