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

0
votes
0answers
6 views

MySQL: physical table vs temporary table

This question is part of this question MySQL: excessive memory usage I am in process of debugging MySQL high memory usage, I need to know the difference and impact of the physical tables and ...
0
votes
0answers
5 views

MySQL: excessive memory usage

In our production system, MySQL service uses above 95 % of the available memory. System Info: OS: CentOS 6 RAM: 32 GB CPU: 4 core MySQL version: MySQL 5.5 Database Size: 158 GB my.cnf info: # ...
3
votes
0answers
46 views

Do Large Hash Joins Contribute to Stolen Pages?

On a SQL Server 2014 SP1 Enterprise Instance, I'm performing an outer join between two partitioned tables on a numeric(16,0) + char(1) composite key. 100 GB is the max server memory setting on a 128 ...
1
vote
0answers
37 views

Why is my server with memory pressure when I have 4.3GB available memory? [duplicate]

I'm doing a couple of tests in my local computer and I noticed that the plan cache was being wiped every couple of minutes. After researching a bit I noticed on my error log that my instance was with ...
3
votes
0answers
112 views
+150

Plan cache size and reserved memory

When running a query including the Actual Execution Plan, the root operator (SELECT) tells me that the Cached Plan Size is 32KB. A query that joins sys.dm_exec_cached_plans and ...
0
votes
0answers
24 views

SQL Server 2014 Standard Max Memory vs. Cluster Shared Volume Cache

Deploying a new two node SQL Server 2014 FCI with Storage Spaces on a local (Cluster Shared Volume) CSV—JBOD will be attached directly to both SQL Server machines and the storage will not be tiered. ...
2
votes
2answers
92 views

SQL Server memory usage alert script [closed]

We have a production server with 500GB RAM. max server memory is set to 450GB. Whenever we checked the memory usage it's showing 450GB, but maybe SQL Server reached 450GB for some time? The memory is ...
0
votes
0answers
46 views

Mysql 5.7 crashes/restarts every 20min

Our situation is bit dramatic because we decided to upgrade to mysql 5.7 (5.7.12-0ubuntu1) from previous server with mysql 5.6 in production (new installation importing dbs from dumps). New server ...
0
votes
1answer
46 views

solve high stolen memory

I've a SQL Server 2012 SP2 with max memory set to 13GB but there is 8GB of stolen memory (SQLServer:Memory Manager - Stolen Server Memory (KB)). I know stolen memory is memory taken from the ...
1
vote
0answers
52 views

MySQL is using swap memory while I have plenty of free RAM

I have a 6 GB buffer pool size for my database; however, mysqld process is moving to swap while there is plenty of RAM available. I think pool size and pages along with pool of reads and pool of read ...
1
vote
1answer
41 views

What is the fastest way to insert data into MySQL memory table?

I need to insert 10M+ records into a MySQL memory table. A naive approach was to pipe records using shell, e.g. $ tail -10 ~/Desktop/test.sql INSERT INTO `test` (`a`, `b`) VALUES (4, 5); INSERT INTO ...
3
votes
0answers
55 views

Why would Stolen Memory counter be at a constant high? [duplicate]

I'm trying to understand memory stats a lot better and have been troubleshooting an issue with one of our SharePoint DB servers for a while now. Low PLE, frequent lazy writes, slow performance etc I ...
1
vote
0answers
18 views

db2: configurations covered by “create db autoconfigure”

I am new to configuring memory in db2. I want to create a database using this command: db2 CREATE DB TEST USING CODESET UTF-8 TERRITORY US AUTOCONFIGURE USING mem_percent 80 APPLY DB ONLY According ...
3
votes
1answer
52 views

Buffer Cache Size when Page Life Expectancy Drops

I'm troubleshooting an issue with one of our SharePoint databases, essentially huge drops in PLE which I think are caused by increased I/O activity (I see increased reads, writes and lazy writes at ...
0
votes
0answers
75 views

SQL Server not using all the memory

We have a server with 32 GB of RAM, Windows 2012, 64 bit and SQL Server 2012. SQL Server is not consuming all the memory available on the server. Max and min settings are in place. No resource ...
2
votes
1answer
70 views

Troubleshooting memory pressure - how to avoid paging out SQL Server?

I have received the email below that states that an alert has been fired and a significant part of SQL Server process memory has been paged out should I raise the Minimum server memory to 1740 ...
2
votes
1answer
145 views

App Domain unloaded when using GDAL/OGR ogr2ogr to insert many Geometry records

SQL Server 2012 x64, Total memory allocated 2GB, set to low value to enable us to reproduce "AppDomain unloaded" issues much quicker Windows Server 2012, Total Memory on Server 16GB (in ...
0
votes
1answer
44 views

Memory usage of MongoDB

I've got Django app with mongoengine, which executes some aggregation-queries often enough. The main problem is that mongod takes all the RAM and then crashes, so no LRU working, mongod just trying ...
0
votes
0answers
7 views

Is it advisable to configure huge pages on SLES for MySQL

What is a general opinion on using huge pages with MySQL server? As described in here: https://dev.mysql.com/doc/refman/5.7/en/large-page-support.html Or is it best to leave things as is and not ...
0
votes
3answers
52 views

Mysql query larger than tmpfs (ramdisk)

I recently set up a ramdisk tmpfs on our mysql server and the performance improvement has been quite noticeable. I've allocated 24 out of 32 GB's of ram for the ramdisk. My only concern is what ...
7
votes
2answers
285 views

SQL Server not using all memory

I have SQL Server 2014 with max memory set to 6GB (physical memory is 8GB). The Target Server Memory is sometimes 6GB and then drops back to Total Server Memory (approx 5.3GB, never reaches 6GB). I ...
0
votes
0answers
24 views

MongoDB collStats.size compared to collection.totalSize

I have a collection which has the following dimensions: rs0:PRIMARY> db.myCollection.totalSize() 2188206080 rs0:PRIMARY> db.myCollection.stats() { "size" : 5899660704, "avgObjSize" : ...
1
vote
1answer
31 views

no free memory but low total memory

I have SQL Server 2012 SP2 that has a max memory of 25.4GB but SQL Server is only using 15GB. When I check free memory with the PerfMon SQLServer:Memory Manger Free Memory (KB) counter only 40MB is ...
2
votes
1answer
22 views

In [Percona] MySQL, is the Adaptive Hash Index included in the Total memory allocated count?

I'm debugging a memory problem with MySQL 5.6 (I'm using the Percona distribution), but I can't figure out, searching around the web, if the Adaptive Hash Index amount is part of the Total memory ...
2
votes
2answers
29 views

MySQL lock on MEMORY storage engine, when does it apply?

I want to use MySQL MEMORY storage engine to handle my PHP session variables (actually I already implemented it but since all my tests are being done by a single user, me, I am unable to notice this). ...
1
vote
0answers
40 views

Failed to allocate reserved pages: FAIL_RESERVED_PAGE_ALLOCATION

Last night I received the error on one of my servers of: Failed to allocate reserved pages: FAIL_RESERVED_PAGE_ALLOCATION 2047 I know that this has already been discussed on here some but all ...
0
votes
2answers
54 views

Memory leak on MySQL slave?

I have a Percona MySQL master-slave server configuration(5.6.20-68.0). The memory usage by MySQL on the slave server is constantly growing. Now it reached 68G despite on fact that ...
0
votes
1answer
37 views

Memory usage increases whenever I run stored procedures [duplicate]

I want to know why SQL Server memory use increases whenever I run stored procedures. After I stop and restart SQL Server, the memory used is just 1 GB. Each time I run stored procedures, the memory ...
1
vote
1answer
73 views

SSIS Buffer/Memory Failure

I get this error when running SSIS package... A buffer failed while allocating 104857600 bytes. The system reports 31 percent memory load. There are 17179328512 bytes of physical memory with ...
1
vote
0answers
63 views

A significant part of SQL Server process memory has been paged out

Around 7:30pm every evening we receive the following message and the server experiences an outage of 2 minutes. A significant part of sql server process memory has been paged out. This may result ...
1
vote
0answers
69 views

Unexpected Memory Pressure - RESOURCE_SEMAPHORE wait

Update I've done some further investigation into this issue and could still do with some help understanding what's going on. After restarting the instance, I monitored memory allocations over time, ...
0
votes
0answers
32 views

Is it possible, when using LPIM, for one database to allocate the majority of the memory?

Windows Server 2012 R2 SQL Server 2012 Enterprise (maximum server memory: 200,000MB) 224GB memory LPIM enabled physical_memory_in_use_kb 204703788 large_page_allocations_kb 1128448 ...
0
votes
0answers
27 views

MySQL Storage Engine and Memory

I recently found out that, the databases does not have standard architecture(data model), some of them are, No relationship between tables(entities). No indexes defined. Only integer and varchar ...
1
vote
2answers
53 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
34 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
142 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
100 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
33 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
29 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
82 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 ...
3
votes
0answers
307 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
171 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
157 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
104 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
832 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
228 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
44 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
36 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
167 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
320 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 ...