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
72 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
27 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
84 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
78 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
3answers
90 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
89 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
854 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
175 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
586 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
917 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
105 views

mysql uses too much memory

Current configuration: +------------------------------------------+--------------------+ | key_buffer_size | 64.000 MB | | query_cache_size | ...
1
vote
1answer
303 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
46 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 ...
5
votes
1answer
550 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
30 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 ...
5
votes
1answer
117 views

SSAS - what could be a good starting point for memory settings?

I have received the following alert regarding memory settings of SSAS: Alert: SSAS 2014: Invalid TotalMemoryLimit Configuration Source: MSSQLSERVER Path: SASBI01Alert time: 9/15/2015 5:38:50 PM ...
1
vote
1answer
226 views

Why is my Target Server Memory slightly higher than my Total Server Memory?

I'm doing a performance test on a high traffic (16000+ users, estimated 1000+ concurrent at peak) Microsoft Dynamics database. The server has gone on line a few months ago, and I'm doing some tests to ...
18
votes
3answers
295 views

Does CPU utilization affect the cost of foreign NUMA access?

Scenario Let's assume I have a SQL Server with 4 sockets with each 1 NUMA node. Each socket has 4 physical cores. There is 512 GB of memory total so each NUMA node has 128 GB of RAM. A key table is ...
2
votes
2answers
132 views

MySQL: memory requirements for django app with 1 big table (460M rows)

I have created a django app that is running on virtual machine. All db tables are rather small (up to 1M rows) but recently I was asked to add a big table (460M rows). CREATE TABLE `genescorrelation` ...
0
votes
1answer
107 views

Oracle 11g PGA advice view is empty when it shouldn't

I have the following situation in an Oracle 11g server (it's part of a RAC). PGA_AGGREGATE_TARGET is set, STATISTICS_LEVEL is TYPICAL, and yet V$PGA_TARGET_ADVICE shows up empty. Why does this happen? ...
0
votes
0answers
37 views

Hard Limit to SQL Server 2012 Memory Usage [duplicate]

It seems that even in SQL Server 2012, the maximum memory usage settings is not a hard limit. I've read some SQLOS Team blogs about this, and those as well as several MSDN articles seem to state that ...
1
vote
0answers
54 views

MySQL sizing tool for Hardware [closed]

Is there any sizing tool for hardware? I'm not sure what kind of servers we need to offer to my customer like CPU, memory, Disk or number of servers? What kind of questions do we need to ask our ...
1
vote
0answers
106 views

SQL Server 2012 memory issue [closed]

I am having performance issues on a Windows 2012 Server running SQL 2012. When I run the DBCC MEMORYSTATUS command I receive the following. Process/System Counts Value Available Physical Memory ...
0
votes
0answers
32 views

SQL Server 2012 memory issue [duplicate]

I am having performance issues on a Windows 2012 Server running SQL 2012. When I run the DBCC MEMORYSTATUS command I receive the following. ...
1
vote
0answers
17 views

Access algorithms in Partial Index implementation of PostgreSQL 9.4?

I am studying big-O time-space complexities of different algorithms with the partial index of PostgreSQL 9.4: introsort (O(n log n)-time, O(log n)-space) and heapsort (O(n log(n))-time ...
2
votes
1answer
21 views

Address Windowing Extensions Overhead

I just found another SQL Server (2008r2) with AWE enabled on a 64-bit OS/SQL combination. Has anyone done an research as to the overhead created by enabling AWE on the 64-bit OS/SQL combination? It ...
4
votes
2answers
82 views

Virtualized SQL Server Memory Oddity

I've not seen this before, though perhaps it is common. I am looking at a virtualized (VMWare 5.5) SQL Server (2008R2 on Windows 2008 R2). What I am seeing is that in Task Manager*, sqlserver.exe is ...
2
votes
1answer
73 views

SSAS and SQL Server on the same server

I have a server that is primarily used for SSAS, heavy processing, however I have SQL Server on it alongside SSAS, but I don't want sql server to hold ssas back. I have set the SQL Server MAX memory ...
5
votes
2answers
2k views

sql server max memory includes SSIS?

I have installed 2 instances of sql server plus SSIS on the following server. Note the amount of RAM is nearly 384 GB And this is the max and min memory settings that I have applied to my 2 ...
1
vote
0answers
110 views

Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads

I am trying to improve the performance of Postgresql (version 9.2.3) inserts for a simple table with 1 bigint, 1 varchar, 1 float and 2 time stamps. A simple replication of my JDBC program is ...
0
votes
1answer
52 views

Setting shared_buffers over 320 MB prevents Postgres from restarting

I'm running Postgres 8.1 on a CentOS 5 system with 4 GB of RAM. Whenever I set shared_buffers above 320 MB, it won't run. I've checked SHMMAX and it's at 4294967295 which is the max allowed for a ...
3
votes
1answer
155 views

MariaDB Spider Engine Out of Memory

I had almost standard MariaDB with InnoDB engine working fine but I wanted to test out the Spider Engine + Sharding/Partitioning. I had a query which was passing fine on the MariaDB InnoDB for ...
1
vote
0answers
126 views

A significant part of sql server process memory has been paged out. Lots of free memory though

Having a problem where my SQL Server 2012 SP2 Enterprise server says that most of SQL Server's memory has been paged out to disk but there's over 100GB free (of 256GB). From there system performance ...
1
vote
1answer
54 views

How to determine RAM usage of a query

I would like a detailed explanation on the below question. This is regarding the Mysql RDBMS. Thanks in advance. What are the factors that would affect the RAM usage by a query. how to ...
2
votes
2answers
489 views

Would increasing innodb buffer pool size prevent a mysql crash?

My server keeps running out of memory for mysql. I keep getting. 150708 3:39:09 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 258064 bytes) When I looked in my.cnf I saw that ...
2
votes
1answer
151 views

SQL Server process only using half of the memory on host

We doubled the memory on host that has a SQL Server Enterprise 2014 instance on it. After a reboot of the server we noticed that the SQL service is only using half of the memory. A little background ...
3
votes
3answers
146 views

RAM utilization

We are using SQL Server 2014 on Windows server 2008 Web edition (64 bit). Total RAM of OS is 8 GB .When we check high physical memory usage in the task manager it shows nearly 90 to 95 % full but I ...
7
votes
2answers
938 views

Why is SQL Server 2014 consuming so much RAM with no active data stored?

I'm running SQL Server 2014 on my laptop along with a ton of other installed applications, from Visual Studio to video games. This is obviously not a production server, but for development and ...
2
votes
2answers
945 views

How do I limit Oracle's memory use?

I would like to use Oracle's automatic memory management, with a limit of around 4GB. (Past experience has shown this to be plenty for my dev PC and that it is easier to get an idea about any ...
10
votes
3answers
407 views

Configure RAM for SQL Server and NUMA

Accidental DB admin here. Question: Would you still manually limit max RAM for SQL Server even though the sole purpose of that server is to serve SQL Server database engine only? I have Microsoft ...
3
votes
1answer
114 views

ORA-00845 after deleting files accidentally at /dev/shm

I have two instances (ORA1 and ORA2) of Oracle 11g at the same machine. One is starting the other cannot startup anymore. What happend: First my disk was full, so I accidentally deleted all ...
2
votes
0answers
138 views

MEMORYCLERK_SQLOPTIMIZER in SQL 2012 Memory usage extremely high and causes server to crash

I have been having issues with our SQL server for a while now. It seems to run out of memory every few days and when I look at the memory dump, the MEMORYCLERK_SQLOPTIMIZER seem to take over memory ...
5
votes
1answer
119 views

SQL Server 2012 Crashes and service doesn't restart

We've been having an issue with our SQL server lately. It seems that the server will run out of memory and then crash. For some reason, the sql service wouldn't restart. I would have to go and ...
4
votes
1answer
254 views

NUMA Nodes - MAXDOP - PLE

We have a server with 8 CPUS across 2 NUMAs with hyperthreading enabled. Currently Maxdop is set to 8, but actually should be set to 4 as per the Maxdop section of this article: ...
0
votes
2answers
246 views

MySQL Server > 90% memory consumption

I have a fairly large (16 vCPU / 47 GB of RAM) linode box which hosts a running MySQL Server. This box currently does nothing else (and we are not planning to install anything else on it for now). ...
0
votes
1answer
191 views

System.OutOfMemoryException SQL Server 2012 and 2008R2

I have a 64-bit and 64gb memory for both SQL Server 2012 and 2008R2, when I generate a report w/c has 900K rows, it finished the query smoothly and no problem, but when I'm going to copy the result ...
0
votes
2answers
129 views

SQL Server 2008 R2 - Memory Allocation

We have a SQL Server 2008 R2 instance that is running on a Windows Server 2008 R2 Enterprise server that has been allocated 128GB of memory. However, it maxes out at 70GB. Can anyone tell me how I can ...
0
votes
1answer
835 views

Memory usage on select for large number of rows

I am trying to dump the entire contents of a large table, from the command line using pqsl, but am running into a problem where memory usage goes up, to the point where the process is killed, before ...
1
vote
1answer
54 views

Increase memory limit when server is stopped

There was a local SQL Server 2012 instance. Once memory has decreased to critical 128 MB and then has stopped by me. I can not start it (idea: not enough memory). Is it possible to increase this ...
0
votes
0answers
72 views

Relationship between file shrink and used memory in SQL Server

Some background info: this is a test SQL Server 2012, with restored databases from production servers, all of them with over 20% space available in the data file, up to even 50%. I'd rather restore as ...