When used in the context of databases, memory refers to RAM directly addressable by the CPU as opposed to going through the I/O subsystem.

learn more… | top users | synonyms

1
vote
2answers
54 views

Contiunous rise of mysqld memory consumption

Mysqld memory consumption rises forever and never seems to be freed. It starts out about 6GB but gradually rises to around 10GB in a few weeks, and of the 10GB only 4GB and 50MB is being used by the ...
0
votes
0answers
53 views

How to add an index to attributes sorted on in mongodb

Before you find another reason for changing the category of this question, it was on Stack Overflow and it was described as a DB Admin question, so here goes: I am running a reporting app with ...
-6
votes
2answers
148 views

Why over 1.3TB desired memory for this query, it should have no memory grant? [closed]

SQL Server version is 2014 Developer SP1. Trace Flags 272, 610, 1118, 1206, 1222, 8048, 9481 are globally turned on. We had to turn on flag 9481 since the new cardinality estimator badly effected ...
0
votes
1answer
110 views

SQL Server 2012 doesn't use enough memory

Under heavy Load, my SQL Server database is executing queries really slowly. I have 96 GB of RAM and my CPU is high (100%) but my physical memory usage is at 9%. I looked at the SQL Server memory ...
0
votes
1answer
34 views

Maximum Server Memory adjust in blocks of 1024MB?

Our protocol is to set Maximum Server Memory at about 75% of RAM. For a 4GB RAM, sometimes it gets set at 3000MB and sometimes to 3072MB. There is a 2 or 3 percent difference in these values. Is ...
0
votes
0answers
34 views

Unexplained MariaDB/MySQL memory jump

All of a sudden the memory usage of my MariaDB instance has jumped from around 1.5GB to 6GB. A restart briefly solves the issue, but slowly creeps back to the peak value. Stopping all processes that ...
1
vote
1answer
85 views

MySQL difficulty with optimizing slow query with index but without improvement. Explains tells otherwise

I've a slow query (~11 seconds) that I'm trying to optimize. But the use of indexes seems to not make any difference even thou Explain indicates otherwise. Let me walk you through my problem. So this ...
4
votes
0answers
479 views

MySQL 5.7 + Ubuntu 14.04 eating up my RAM

I've recently installed MySQL 5.7.11 in my Ubuntu 14.04.3 system following these instructions: http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/ Being totally empty and not being called by any ...
1
vote
2answers
319 views

The database manager failed to allocate shared memory because an operating system kernel memory limit has been reached

I have installed IBM DB2 10.5.5 and I want to create a new database there. When I entered command db2 create database test1 I am getting a error saying SQL1084C The database manager failed to ...
0
votes
1answer
192 views

SGA size not decreasing after reducing memory_target (Oracle 11.2.0.1)

I have an Oracle 11.2.0.1 database using dynamic memory allocation with parameter MEMORY_TARGET. When I decrease it with SCOPE=BOTH, the size of the SGA doesn't seem to decrease along with it. I have ...
1
vote
1answer
150 views

Maximum possible memory usage over 100%

During these days I experienced several problems (delay and failed restart) on my database MySQL, so I tried with some help here around (and using Percona service too) to optimize my /etc/mysql/my.cnf ...
5
votes
2answers
933 views

Maximum SQL Server memory set to 12 GB, but it still goes over 12 GB. How do I prevent SQL Server going over max memory limit?

User 'mrdenny' wrote that after you set SQL Server maximum memory... Now this isn't going to limit all aspects of SQL Server to that amount of memory. This only controls the buffer pool and the ...
5
votes
1answer
385 views

There is insufficient system memory in resource pool to run this query

Over the past year we have been suffering a situation where many different queries at the same time will fail with the following error (or a variation in a different resource Governor group): There is ...
0
votes
2answers
48 views

MySql not using Buffer Pool

I'm checking into a buffer pool issue on a MySql database. According to the query to get database size shown here, the total database size is about 11GB. Unfortunately I know I have much less RAM than ...
3
votes
0answers
39 views

High paging and memory consumption in SQL Server [duplicate]

This is my first question about SQL Server, I'm new to SQL Server and I don't understand few things, so hope you can help me. We got a SQL Server 2008 with 2 instances and also with Analysys Services ...
1
vote
1answer
299 views

Don't preallocate many gigs of ram in Oracle Database 12c?

I've just installed Oracle Database 12c Enterprise for Windows. The first thing I've noticed is it preallocates almost 10GB ram. How can I configure Oracle to only allocate and deallocate ram as ...
4
votes
2answers
623 views

SQLServer:Buffer Cache Hit ratio is a good indication of POSSIBLE memory bottleneck?

I am looking for an indication (if any) that would either disregard the memory bottleneck option, or accept it, or make me investigate further. for instance: page life expectancy: SELECT [...
2
votes
2answers
224 views

PostgreSQL is using more memory than I'd expect

I have PostgreSQL configured mostly how pgtune recommended, and the settings are supposedly conservative. PostgreSQL is using more memory for a single connection than the settings would suggest is ...
5
votes
2answers
119 views

Can SQL Server (2012-2014) be configured to run “on-demand?”

I am very, very new to SQL, and am having difficulty configuring the server appropriately. All I have to work with for now is a small copy of the database schema of the company I work for, with ...
0
votes
0answers
410 views

MySQL Tuner script to optimise MariaDB 10.1 install on 512MB VPS - MySQL's maximum memory usage is dangerously high

I have installed MariaDB 10.1 onto a 512MB CentOS 7 x64 VPS & enabled InnoDB. On this machine, I am also running NginX (1 worker process) & PHP-FPM (2 child, 2 spare) with php.ini memory limit ...
4
votes
1answer
357 views

SQL Server 2012 Express high Commit (KB) (low virtual memory condition)

I have a customer running SQL Server 2012 Express Edition: Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Express Edition (64-bit) on ...
0
votes
2answers
76 views

Disable MEMORY_TARGET after being locked out of database?

I'm setting up a local development environment in a virtual machine in which I installed Oracle XE among other software. When I initially set up the virtual machine, the RAM was set to 4Gb. In this ...
0
votes
0answers
31 views

T-SQL script to analyse recent changes in SQL Server configuration?

Last week suddenly one of our VMs running SQL Server slowed down considerably and its performance dropped to the level where some of us cannot work on it any more. Just to give you an idea about the ...
1
vote
1answer
49 views

On an idle instance, why does setting max memory to 256mb cause %CPU to jump

Five 2012 instances on a 2-node cluster using AVGs. Two of them doing nothing yet, no user databases or users. Customer insists on specific max mem settings while waiting for additional memory ...
1
vote
1answer
491 views

memory usage oracle query

We see Direct path read temp frequently in the database. It started with one query and later followed up to all the queries running in database at that moment. I understand that data is read from ...
3
votes
2answers
215 views

Release MySQL Memory and Performance Tunning

I am new to the MySQL database. I have recently installed MySQL 5.7 and configured the my.ini file. Please find the below copy of the file. The server is a dedicated server for MySQL database and the ...
2
votes
1answer
70 views

Using an index on a Postgresql integer range causing trouble

Unfortunately I was not able to create a usable example / fiddle. But I am using a Postgresql 9.4 table that looks somewhat like this: CREATE TABLE table1 (id INT PRIMARY KEY NOT NULL, dtype TEXT, ...
1
vote
3answers
658 views

How to decrease RAM usage of SQL Server 2012 without restarting Service

Is there a way of decreasing RAM usage of SQL Server 2012 without restarting it? Setting up MAX Memory usage is not an option as it's quickly building up to limit I have set and then app based on ...
4
votes
1answer
81 views

SQL Server Memory Shrinking

I had a strange issue today on a 3rd party vendor's SQL Server. This is a VM running SQL Server 2012 SP1. The min and max memory settings are set to 9GB. Task manager showed SQL Server was getting the ...
1
vote
1answer
908 views

#1041 - Out of memory issue in mysql [closed]

I am using Amazon RDS db.m1.medium instance. It has at least 40-50 database and atleast 10k table. For last one year it was working fine, but today I was altering one table It started giving error. I ...
2
votes
1answer
258 views

Unable to turn off automatic memory management (AMM)

i am running oracle 11.2.0.4 SE RAC on Red Hat linux 6, the database is using ASM for datafile management i have been experimenting with turning on AMM and set the following parameters alter system ...
1
vote
1answer
555 views

Mysql Tuning for a small server

I have a small Cloud Server running under Ubuntu 2 core, 2GB ram and 2GB swap, with Plesk Panel, Apache, Nginx as reverse proxy and Mysql 5.5. I have about 18 domains hosted here and each domain has ...
1
vote
2answers
124 views

Would SQL Server in a Cluster failover if it is running out of RAM

I have a SQL Server 2008 R2 in a Cluster in an active-passive mode. The server is running out of RAM (both physical and pagefile). In the instance level settings there is not Max RAM set (set to the ...
1
vote
2answers
42 views

I changed the max memory setting but I don't see memory usage rise at OS level

We have increased the RAM capacity on the OS to 40G and I have changed the max memory parameter to 36G in SSMS. When I select "current value", it shows 36G. However, monitoring memory usage at OS ...
0
votes
1answer
29 views

Does mysql “lock” (no other process can take from it) the memory allocated to it?

I have a 64GB memory machine, and I set mysql buffer pool to be 40GB. So MySQL is using up to 40G memory while it's running. I kicked off a java application that requires more than 20GB memory, so ...
0
votes
0answers
84 views

Memory usage still growing

I have problem with my production mysql server. The memory usage is still growing and I don't know why. Trouble started when we changed the server. My mysql version: 5.5.44-0+deb8u1-log - (Debian). [...
0
votes
0answers
30 views

Enormous MySQL 5.5 Handler_read_rnd_next

The value of Handler_read_rnd_next is actually 91,3 G on my Database server but I am pretty sure that all tables have proper indexes. I am 100% sure that there is no query with a WHERE clause that ...
0
votes
1answer
104 views

SQL Server Memory Cap reached its maximum state and threw an Out Of Memory Exception

We have set a memory cap limit of 43GB in SQL server instance, so thereafter it keeps 42 GB near about and keeps near about 1 GB for its processing operations. But then we received near about 500,000 ...
2
votes
1answer
103 views

Why is Page Life Expectancy value sometimes exceptionally high (4,3 M)?

My value of PAGE LIFE EXPECTANCY usually is in a range of 3000 - 10000. But as you can see in the little data sample below, there are regular values of about 4,3 Milion. I get those values using ...
6
votes
2answers
114 views

Query Processing & The Buffer Pool

When SQL Server Server 2008r2 begins to process a query, I know it needs to parse the SQL Text and create the plan, plus a few other steps. It is doing all of that in memory OUTSIDE of the buffer ...
3
votes
2answers
100 views

Why is server configuration 'min server memory' configured at 0, but running at 16 (sometimes 8)?

We started to monitor sql server instance non-active server configurations and find something interesting. Why is server configuration 'min server memory' configured at 0, but running at 16 (sometimes ...
4
votes
1answer
1k views

DB Engine Stolen Server Memory is too high

I get error from System Center Operations Manager (SCOM). How to solve this error? SQL DB 2012 Engine Stolen Server Memory is too high. I run query and get this counters: ╔════════════════════...
2
votes
1answer
223 views

SQL*Loader-926, ORA-04031 unable to allocate x bytes of shared memory

A customer received this error while importing serveral files. The import routine (VB.NET) is using SQL*Loader (Release 11.2.0.3.0) via Process on each table separately (64 in total) and is called ...
4
votes
1answer
623 views

Do I have a memory issue?

I ran sp_Blitz that pointed me to a memory issue saying: Memory Dangerously Low The server has 32755 megabytes of physical memory, but only 235 megabytes are available. As the server runs ...
2
votes
2answers
2k views

AppDomain 2 (mssqlsystemresource.dbo[runtime].1) is marked for unload due to memory pressure message in SQL Server Log

From last two days I can see following in SQL Server errorlog. AppDomain 2 (mssqlsystemresource.dbo[runtime].1) unloaded. & AppDomain 2 (mssqlsystemresource.dbo[runtime].1) is marked for unload ...
0
votes
2answers
111 views

mysql uses too much memory

Current configuration: +------------------------------------------+--------------------+ | key_buffer_size | 64.000 MB | | query_cache_size | ...
1
vote
1answer
332 views

Would daily/weekly db memory cache clearing be of use?

So memory use is hitting limits. Would clearing the database memory cache on a daily/weekly schedule be of use? (Ignoring the fact I probably should be looking at reducing size of database/indexes) ...
3
votes
1answer
50 views

Does it make sense to limit Mongo RAM?

I have a Windows server running MongoDB. My database has big indexes and all RAM is usually busy. As I know, it can be a cause of Windows swapping and performance issues. Does it make sense to limit ...
6
votes
1answer
800 views

PostgreSQL could not fork autovacuum worker process: Cannot allocate memory

Running into some issues every few days with postgres crashing and entering recovery mode. The logs from postgres look like so ... Lots of this for 5-10minutes 2015-09-24 10:07:27 GMT LOG: could ...
1
vote
0answers
31 views

SSAS - what could I monitor in SSAS to fine tune its memory settings?

This question is a follow up from the SSAS - what could be a good starting point for memory settings? What and how can I monitor the server resources in order to best identify the settings that I ...