by XTIVIA | Jan 7, 2016 | Blog, Databases
DB2’s Self-Tuning Memory Manager (STMM) was introduced in DB2 9.1. The default for new, single-partition databases was ON from the beginning. What is STMM? DB2’s Self-Tuning Memory Manager can allocate and change the size of specific memory areas including...
by XTIVIA | Dec 17, 2015 | Blog, Databases
Memory usage can be an issue for DB2 whether a server has 2 GB or 2 TB of memory. There can be issues with making DB2 use all of the memory, and there can be issues with DB2 causing paging or even kernel panics. Because of this, it is important to understand how much...
by Matt Wolinski | Feb 25, 2015 | Blog, Databases, Enterprise Infrastructure
I was recently working on a client’s site and ran into the following warning: WARNING: You are running on a NUMA machine. We suggest launching mongod like this to avoid performance problems: numactl –interleave=all mongod [other options] This warning shows...
by Kathleen Long | Dec 19, 2012 | Blog, Data Management, Databases
An interesting request came in the other day, is there a way to tell how much memory each database is using on an instance. You can always use properties to see how much memory is allocated to the SQL Server and there are performance counters available to track how...