Question : My current storage engine is WiredTiger and its compression level is as default, snappy. I’ve come across MongoDB […]
Tag: memory
Run out of virtual memory after added to triple physical RAM and change SQL Server memory option?
Question : Recently, we added some physical RAM to our server which running SQL Server 2008 R2 instance, the total […]
How memory limit for backup process is calculated?
Question : How “memory limit” for backup process is actually calculated? Answer : You must have got the output after […]
SQL Server Query Performance Severely Regresses due to High Memory Use
Question : Moved from StackOverflow. Scenario I have a ASP.NET Core 5 (.NET 5) project that deals with GPS devices […]
Why is MySQL is creating so many temporary tables on disk?
Question : Can any configuration mistake lead to creating too many temp tables by mysql..mysql tuner shows Current max_heap_table_size = […]
SQL Server becomes slower over time until we have to restart it
Question : We have a database with a mixed OLAP/OLTP workload. The queries are quite ad-hoc and are dynamically created […]
Plan cache memory: parameterized SQL vs stored procedures
Question : In making a case to disallow parameterized SQL in my company’s development environment the lead developer related a […]
MySQL using more memory than expected
Question : We recently upgraded a database server from Ubuntu 14.04 to Ubuntu 18.04, and at the same time upgraded […]
MariaDB (RDS) going temporarily offline (with memory drop)
Question : We have an issue with a database of ours on RDS running MariaDB 10.4.8 on a t3-large instance […]
SQL Server 2012 Very Slow to Consume Memory
Question : I have a bit of a conundrum. I recently upgraded a ~20gb database from Window Server 2008 R2 […]