Question : I’ve done some tests in order to investigate performance issue on the new HP Gen8 server (Intel(R) Xeon(R) […]
Tag: memory
MongoDB terminates when it runs out of memory
Question : I have the following configuration: a host machine that runs three docker containers: MongoDB Redis A program using […]
More committed than physical memory, how is that possible?
Question : This is on SQL Server 2019, running on Windows 10 with 64GB or RAM. Trying to solve a […]
Should Amazon RDS SQL Server 2017 Web Edition Max Memory settings be different from that of a locally installed instance?
Question : We have an Amazon RDS SQL Server Web Edition on Windows Server 2012 with 2 processors and 8GB […]
Increased memory to server, but do I need to change page-file size?
Question : I’m running SQL Server 2017 on Windows Server 2012 R2 and have increased the memory from 256 GB […]
Whether `SQL Server: Memory Manager: Target Server Memory (KB)` is ideal amount of memory based on recent workload OR the max memory setting?
Question : Link: https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-memory-usage?view=sql-server-ver15 SQL Server: Memory Manager: Target Server Memory (KB) This counter indicates an ideal amount of memory […]
MySQL: memory requirements for django app with 1 big table (460M rows)
Question : I have created a django app that is running on virtual machine. All db tables are rather small […]
MariaDB Galera setup with drastically different amounts of memory used on cluster nodes – why?
Question : We have a 3 node MariaDB Galera cluster. All nodes are identical and the config on each is […]
What are the downsides of running DBCC FREESYSTEMCACHE (‘TokenAndPermUserStore’) hourly?
Question : I have been seeing some concerning behavior in the SQL Server memory caches on one of our production […]
Buffer usage for index with no reads
Question : Using SQL Server 2008 R2, the main transactional table in a vendor database is massive compared to all […]