2022 Developer Survey is open! Take survey.

Questions tagged [memory]

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.

Filter by
Sorted by
Tagged with
-2 votes
0 answers
32 views

Does PLE have any relation to the backups performed? [duplicate]

Page life expectancy tells how many seconds a page remains in memory. Backup uses backup buffers which are separate to the sql server buffer pool memory. So this means that when a backup is performed, ...
user avatar
  • 2,285
-1 votes
1 answer
41 views

What is the reasoning behind allocating the OS 1GB for each 4GB of RAM?

Link: https://codingsight.com/understanding-the-importance-of-memory-setting-in-sql-server/ Let us now briefly look at the techniques to size the memory. 1 GB of memory reserved for Operating System ...
user avatar
  • 2,285
3 votes
2 answers
58 views

Whether `SQL Server: Memory Manager: Target Server Memory (KB)` is ideal amount of memory based on recent workload OR the max memory setting?

Link: https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-memory-usage?view=sql-server-ver15 SQL Server: Memory Manager: Target Server Memory (KB) This counter ...
user avatar
  • 2,285
0 votes
0 answers
21 views

A INSERT SQL is MySQL use memory too much, and mysql oom

when MySQL is running a insert data, the count of number is about 20w, and is about 100M but the memory useage is about more than 4G *************************** 1. row *************************** ...
user avatar
0 votes
0 answers
15 views

What can cause MEMORYCLERK_SOSNODE clerk gradually taking available memory in SQL Server 2019 CU14?

One of our production server is crashing after every few weeks due to low memory. We found that the instance memory is taken by MEMORYCLERK_SOSNODE clerk. When this clerk gradually use available ...
user avatar
0 votes
2 answers
32 views

SQLCONNECTIONPOOL growing very huge

One of my db server SQLCONNECTIONPOOL growing very huge,it consumed 55GB , out of 65Gb (sql MAX) memory) Environment: Microsoft SQL Server 2017 (RTM-CU25) Standard Edition How can i reduce the ...
user avatar
0 votes
5 answers
51 views

MySQL's maximum memory usage is dangerously high

I'm trying to understand what is not working in my configuration. When I run the [root@server ~]# ./mysqltuner.pl >> MySQLTuner 1.9.8 * Jean-Marie Renouard <jmrenouard@gmail....
user avatar
0 votes
1 answer
148 views

Free node memory and low PLE

We run a SQL Server 2014 standard edition on a 94 GB RAM server with 82 GB RAM dedicated to SQL. I know PLE is not the answer to all and we should not focus on it too much. But if you look at the ...
user avatar
  • 1
4 votes
1 answer
2k views

What does the maximum SQL Server memory configuration limit?

Suppose I limit the SQL Server memory to 100 GB. Does this only limit the buffer to 100 GB or does it also limit the query memory grants?
user avatar
  • 2,285
-1 votes
3 answers
112 views

How to benchmark the memory requirement fo sql server?

I have a production sql sever with 200GB ram. Of this 150GB is allocated to sql server (by setting max memory settings in sql server properties) The rest is used by ssis, os, anti-virus, apps. I want ...
user avatar
  • 2,285
0 votes
1 answer
37 views

SSMS -- inhibit results or remove temporary files when query is done

I am running several instances of the same query to establish baselines for potential performance optimization. That is, I want to compare timing for two versions of the same query. I am using SSMS ...
user avatar
0 votes
0 answers
35 views

SQL Server 2014 consuming more memory than max server memory setting

For the past month, I have noticed our SQL Production server has been consuming more memory than we allocated for it. This is the current structure: Total OS Ram: 31Gb SQL Server currently using ...
user avatar
0 votes
1 answer
66 views

Does innodb_buffer_pool_size setting affect update queries?

I have a huge database(16GB) to which I wish to add a new column based on an existing column. The existing column looks like this:- MariaDB [demo]> SELECT my_mon FROM mytable; +----------+ | my_mon ...
user avatar
1 vote
2 answers
113 views

Memory utilization by SQL Server 2016 [duplicate]

I am running a SQL Server 2016 Enterprise Edition on Windows Server, with 128 GB of memory. During installation, I assigned 124 GB to the SQL server, since the server is dedicated to SQL only, leaving ...
user avatar
  • 11
0 votes
0 answers
40 views

MS SQL: Out of memory happened while accessing a critical resource

How do I go about resolving "Out of memory happened while accessing a critical resource" errors? I have sufficient RAM (1.82TB) on a VMWare Win 2016 Std; MS SQL 2019 CU12 Ent 32 cores with ...
user avatar
  • 1
11 votes
2 answers
2k views

SQL Server is using a lot more RAM than it should

I have a SQL Server 2012 instance using more RAM that it should. The SQL Server process is using about 22.5GB RAM: The instance is configured to use a maximum of 10GB: Which is way more then ...
user avatar
1 vote
1 answer
67 views

Does the query still run even when SQL Server can't grant the requested memory for the query?

I was thinking about something like this today but I couldn't find this piece of information. When the SQL Server requests memory and the OS can't provide it, we get a RESOURCE_SEMAPHORE wait type. ...
user avatar
  • 7,100
3 votes
2 answers
597 views

SQL Server 2017; Memory troubleshooting; There is insufficient system memory in resource pool 'internal' to run this query

We are running a local SQL Server 2017 to support a datawarehouse database. The database is loaded on a schedule through SSIS largely through the use of staging tables and the MERGE function. Recently,...
user avatar
  • 126
2 votes
1 answer
505 views

More committed than physical memory, how is that possible?

This is on SQL Server 2019, running on Windows 10 with 64GB or RAM. Trying to solve a memory issue I found a post where the following query was used: SELECT virtual_address_space_reserved_kb as ...
user avatar
  • 148
0 votes
3 answers
120 views

How Important is the buffer pool really?

I have been doing some testing of a new (virtual) server which is to replace an existing production server. We suspect the current production server is overspec'ed and therefore are tweaking the ...
user avatar
  • 1,450
0 votes
0 answers
89 views

Materialized view creates quickly with data but cannot refresh

I am working with a database on Amazon RDS and have a specific query which joins about 6 tables on keys. Creating the materialised view with data takes about 3 minutes and behaves as expected with ...
user avatar
1 vote
1 answer
115 views

Temp files and work_mem

My Postgres instance is logging things like this: 2021-11-16 22:18:52.491 UTC [1808765]: [3-1] db=xxx,user=xxx LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp1808765.0", size 262144 My ...
user avatar
-1 votes
2 answers
83 views

MariaDB seems to be locking all the tables

I am running MariaDB locally on windows 10. XAMPP version 3.2.4 and MariaDB Version 10.4.7 I am moving MYISAM tables to INNODB and trying to prove that the locking issues we seem to be having will be ...
user avatar
  • 1
1 vote
0 answers
42 views

mysqldump increases SQL server process memory footprint

i mentioned my initial problem here in this question (config is still the same): mariaDB with a 3 node galera cluster is eating more and more RAM Now I have narrowed the problem down. I found out, ...
user avatar
-2 votes
1 answer
57 views

How to recover from setting maximum server memory too low? [closed]

On SQL Server 2019, it is possible to configure the server for a smaller than minimum amount of memory (in my case, 100mb). After doing this, the server crashes on startup. Some other forums pointed ...
user avatar
1 vote
2 answers
157 views

"out of shared memory" and lock monitoring in PostgreSQL

I'm trying to monitor an application that uses PostgreSQL (13) to identify what can cause this error (occasionally): ERROR: out of shared memory Hint: You might need to increase ...
user avatar
  • 1,457
0 votes
2 answers
67 views

Why does Microsoft mention "not recommended" for procedure of configuring the SQL memory?

Link: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver15#procedure-for-configuring-a-fixed-amount-of-memory-not-...
user avatar
  • 2,285
1 vote
1 answer
494 views

Azure Database for MySQL - Memory keeps increasing then crashes

I know there are some similar posts as mine but none of them helped me out. I have an Azure Database for MySQL. The average memory usage is above 90% and sometimes the server crashes and restarts. ...
user avatar
  • 13
0 votes
2 answers
95 views

Memory configuration and exhaustion on Always On cluster

I have a 2-node SQL Server Always On cluster hosting 3 SQL Server instances and configured as follows: Total server memory is 768G for each nodes. Memory consumption is 98%. LPIM is activated. ...
user avatar
  • 283
0 votes
2 answers
207 views

How can I configure Automatic Memory Management for certain target values?

I am a little confused about the Oracle Database configuration. My server: Operating system: Windows Server 2012 R2 64bit RAM: 40GB Oracle: Oracle Database 12c (12.1.0.2.0) 64bit My aim: Oracle ...
user avatar
  • 11
0 votes
1 answer
50 views

MySQL memory usage overflow cause VM to reboot

I have 5 mysql servers in master-master group replication setup. (MySQL version 8.0.26) 2 nodes are having 1vCore and 2GB RAM and 20GB HDD configurations, and rest 3 nodes are having about 32GB RAM ...
user avatar
0 votes
0 answers
163 views

Possible memory leak of cx_Oracle/pyodbc/Oracle Instant Client?

Let me first list all the relevant information... Oracle database Version 19.4.0.0.0 Oracle instantclient version: 21.3.0.0.0 OS version: RHEL 7.9 x64 cx_Oracle version: 8.2 pyodbc version: 4.0.32 ...
user avatar
0 votes
1 answer
217 views

mariaDB with a 3 node galera cluster is eating more and more RAM

I am running mariaDB 10.3.29 in a 3 node Galera Cluster on 3 VMs with 14G RAM each. Despite configuring to best knowledge, it continues to eat more and more RAM and after around 3 months the machines ...
user avatar
0 votes
1 answer
47 views

Could hardware RAM disks (with battery) have any benefit in database servers?

For database servers with many writes, I am wondering why can't these ramdisk/ramdrive be a solution to avoid wearing out SSDs and to avoid losing data if too much is kept in normal ram. Can these ...
user avatar
  • 131
0 votes
1 answer
113 views

SQL Server high SQLCONNECTIONPOOL consumption

SQL Server Version : SQL Server 2017(RTM-CU21) on Linux Runing environment : kernel 4.19,Docker 18.09 Docker Image : docker pull mcr.microsoft.com/mssql/server:2017-CU21-ubuntu-16.04 Problem ...
user avatar
1 vote
0 answers
19 views

Container is running beyond physical memory and killed on request (code 143) [closed]

I ran a query which involved a JOIN and an AVG operation: SELECT AVG(user_amount) AS average_user_per_game FROM ( SELECT start_time ,end_time ,COUNT(DISTINCT ID) AS ...
user avatar
5 votes
1 answer
964 views

AppDomain 2 SSISDB is Marked for Unload due to Memory Pressure

I have a stored procedure that joins three large tables together (about 20 million records each) and loads records into a temp table. Data in the temp table is then merged into an existing table of ...
user avatar
  • 157
3 votes
2 answers
220 views

Getting "ORA-04030: out of process memory" on medium insert with large pga and sga

Running on Oracle 12.1.0.2 AIX Power9 (yes, I know it's 2021, but that's the customer I've got) Executing a plsql block that includes 1000 inserts as plain text and commit in the end. begin insert ...
user avatar
  • 141
1 vote
1 answer
463 views

Can't do simple query or drop table due to out of memory error, but pg_locks return no lock

I received this out of memory error when trying to drop a large table (70GB including index) but couldn't identify the root cause from pg_locks view DROP TABLE big_table; ERROR: out of shared memory ...
user avatar
  • 11
1 vote
2 answers
61 views

MySQL:memory used by query joins does not get released

I have a MySQL db running on a 8cpu 24Gb machine. There are multiple scripts writing or reading from it at any point in time, often in parallel. My settings: [mysqld] innodb_buffer_pool_instances = 6 ...
user avatar
0 votes
0 answers
61 views

SQL Server 2012 RAM consumption

I'm running SQL Server 2012 (x64) on a Windows 10 (x64) machine with 64GB of RAM. I've allocated 32000MB to SQL Server. When running a Restore with NORECOVERY, RAM hardly gets used and the job takes ...
user avatar
  • 1
13 votes
3 answers
319 views

How to limit memory consumption of mysql server to prevent OOM kills?

My MySQL instance is getting killed by the Linux oom_killer due to huge consumption of memory by mysql when inserting into longblob columns. This occurs when restoring a mysqldump which contains a ...
user avatar
  • 231
0 votes
0 answers
30 views

initial memory values in ORACLE

I'm confused about memory parameters in ORACLE. In 11.2 we had a simple recommendation: "80% of total RAM, 80% of that size is SGA, 20% is PGA". Then ORACLE introduced pga_aggreate_limit. ...
user avatar
  • 139
1 vote
1 answer
770 views

Understanding why MongoDB uses more RAM than the allowed wiredTigerCacheSizeGB

My mongod command mongod --wiredTigerCacheSizeGB 5 In practice, I'm getting mongo instance to use even up to 8.6 GB (on a VM with 50 GB RAM) Indexes are using about 100 MB (checked with db.stats()) ...
user avatar
  • 117
1 vote
1 answer
70 views

How to figure out what's happening with mongodb?

I am facing an issue where our primary instance of mongodb shows high memory consumption every night. & i was going through the metrics and could see the cache size being reduced and used memory ...
user avatar
2 votes
0 answers
85 views

Source (eg.statement) associated with security memory cache entry (USERSTORE_TOKENPERM / TokenAndPermUserStore)

We are having a security memory cache bloating issue, known as USERSTORE_TOKENPERM or TokenAndPermUserStore. At two different instances (SQL Server 2019, SQL Server 2014 – patched to the latest SP &...
user avatar
  • 935
1 vote
1 answer
148 views

How to reduce MySQL performance_schema memory usage caused by thousands of unique hosts?

I have a problem with some performance_schema tables (*_by_host_* and *_by_account_*) taking up too much RAM. It is caused by clients connecting from a /19 subnet (8190 unique addresses). The ...
user avatar
19 votes
2 answers
2k views

SQL Server in-memory optmized tempdb metadata memory usage continually growing

Problem We have enabled sp_configure 'tempdb metadata memory-optimized' = 1, and now the tempdb meta data is taking over 400 GB on one of our servers and continues to grow. There are some drops in ...
user avatar
0 votes
1 answer
172 views

Error 1041 "Out Of Memory" after pointing tmpdir to new disk space

I want to index a very large column in a very large table. The default /tmp does not have enough disk space and is throwing no space left on device error. I have a much larger filesystem partitioned ...
user avatar
0 votes
1 answer
287 views

How to Prevent High MariaDB Memory Usage on Windows

I am running MariaDB 10.5 and I am having trouble with it using too much memory on my Windows 10 machine. I have 16GB of RAM, and MariaDB ends up using around 8GB. SHOW VARIABLES; https://pastebin.com/...
user avatar
  • 1

1
2 3 4 5
15