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 55

Tuning Database Servers Processing 55

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

​​ Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Servers 40

Servers Cache Database Media 40