Search notes:

SQL Server: Buffer cache

The buffer cache is also referred to as buffer pool.
The purpose of the buffer cache is to reduce disk I/O and thus increase the performance of an SQL Server instance. This is achieved by caching the content of pages in memory.
The content of the buffer cache is revealed in the sys.dm_os_buffer_descriptors view.

See also

sys.allocation_units
architecture
checkpoint, page
Compare with Oracle's buffer cache

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1741107243, '18.217.246.20', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/SQL-Server/architecture/memory-management/buffer-cache(51): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78