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
0 votes
0 answers
5 views

Can Query Store readonly reason 262144 be removed without clearing the Query Store?

I recently had Query Store enter readonly mode due to Readonly Reason 262144. It is documented here 262144 - Size of in-memory items waiting to be persisted on disk has reached the internal memory ...
J. Mini's user avatar
  • 129
0 votes
0 answers
33 views

Do stolen pages (as in sys.dm_os_performance_counters) report anything that sys.dm_os_memory_clerks does not?

I have been under the misconception that SELECT * FROM sys.dm_os_performance_counters WHERE counter_name LIKE 'Stolen Server Memory%'; shows how much memory the OS is stealing from SQL Server. The ...
J. Mini's user avatar
  • 129
-1 votes
0 answers
23 views

SQLServer and memory usage [duplicate]

I have a Windows Server 2019 with SQLServer 2019 Standard Edition. The server has 48Gb Ram + 7 Gb in swap. I saw that SQLServer uses over than 50Gb. There is something to set to force it to act on how ...
Lucio Menci's user avatar
1 vote
1 answer
47 views

Can the plan cache be used to diagnose a lack of RAM?

I have learned a few good ways to diagnose a lack of RAM on a SQL Server and I am wondering if I should add the plan cache to this toolbox. A sign of lacking RAM is that the plan cache doesn't live ...
J. Mini's user avatar
  • 129
0 votes
0 answers
48 views

How can I check the current memory management mode for an oracle database instance?

I have a vendor requesting that Automatic Shared Memory Management (ASMM) is configured to a certain threshold for an existing oracle database (version 19c) hosted on a windows box. As usual Oracle ...
Eric Swiggum's user avatar
0 votes
1 answer
64 views

what sql server is holding in the used memory?

I have a query that shows me how much memory sql server is using, the settings like max memory and min memory, cpu, etc. here is the query: --===========================================================...
Marcello Miorelli's user avatar
0 votes
1 answer
70 views

When do physical reads indicate a lack of RAM?

With Query Store, I can track how big my physical reads are and how often they occur. How can I tell if these numbers are so big that they indicate that I need more RAM? For that it's worth, my other ...
J. Mini's user avatar
  • 129
0 votes
1 answer
43 views

Is Monitoring Buffer Pages Too Noisy To Be Useful?

I quite like dbatools, so I gave Get-DbaDbMemoryUsage (docs here) a try on my production SQL Server 2019 server. Specifically, I ran this Get-DbaDbMemoryUsage -SqlInstance [MyProdServer] -...
J. Mini's user avatar
  • 129
0 votes
1 answer
50 views

76% of the RAM usage on my server is TEXT_MIX_PAGE in tempdb. What does this indicate?

I quite like dbatools, so I gave Get-DbaDbMemoryUsage (docs here) a try on my test SQL Server 2019 server. Specifically, I ran this Get-DbaDbMemoryUsage -SqlInstance [MyServer] -IncludeSystemDbs | ...
J. Mini's user avatar
  • 129
2 votes
1 answer
86 views

RESTORE DATABASE - The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time

While doing a restore of a big database 1.8 TB into a different server I came across this error message when the restore was about 90% completed: 90 percent processed. Msg 3013, Level 16, State 1, ...
Marcello Miorelli's user avatar
1 vote
2 answers
107 views

MariaDB 11.2 using too much RAM

I'm running MariaDB 11.2 in Docker Swarm in Ubuntu 20.04 and its memory usage keeps growing until database is killed by OOM killer. According to MySQLTuner, max memory should be around 7.1GB, but ...
Jakub Marek's user avatar
7 votes
1 answer
767 views

SQL Server: Max memory same as Min memory?

I am currently skimming through Pro SQL Server 2019 Administration: A Guide for the Modern DBA and I have found one thing that somewhat confuses me. In Chapter 5: CONFIGURING THE INSTANCE, the section ...
Yano_of_Queenscastle's user avatar
0 votes
0 answers
102 views

Memory consumption increases after upgrade from postgres 11 to postgres 15

I have some application which make SELECT queries to PostgreSQL database. Currently postgres server version is 11.22 (running in docker container from official image postgres:11.22-alpine3.19). I want ...
AntonioK's user avatar
  • 133
0 votes
1 answer
60 views

why there are differences between sql server max memory and the actual utilization?

I have just asked infrastructure to add memory to a sql server box, the total memory now is 16Gb I have set the maximum memory in sql server to 12GB. when I run the memory query below: SELECT [...
Marcello Miorelli's user avatar
0 votes
0 answers
86 views

PostgreSQL: Parallel Workers Error

For the last two days one of our query causing parallel workers related errors as below, 2024-01-04 13:58:45.988 CST,"user_a","testdb",108428,"10.0.0.1:46480",6596490c....
Basil Titus's user avatar
1 vote
1 answer
36 views

Sudden huge RAM usages with FireBird 4.0

Since about 2 weeks I have a sudden memory issue with 1 of our Firebird servers. For context: We have servers on 4 physical locations, each with a VM dedicated to Firebird and the connecting ERP pack. ...
Jeroen van der Weyde's user avatar
0 votes
0 answers
58 views

Curious Memory Pressure Alert - SQL Server Process Physical Memory Low

We are, on occasion, receiving a SQL Server Process Physical Memory Low alert on one of our warehouse instances. The kicker is, I can find absolutely no indication of memory pressure at the time the ...
mnDBA's user avatar
  • 121
1 vote
1 answer
103 views

View memory usage by database on an SQL server

My team (no DBAs in the team) is responsible for a database hosted on an SQL server with multiple other databases used by other areas of the business. Memory usage has recently been spiking to 100% on ...
user avatar
4 votes
1 answer
801 views

SQL Server memory requirements

At this moment I run into some database performance problems for a SaaS application. During the day the RESOURCE_SEMAPHORE wait stats shoot up to 30 to 60 seconds for 1 or 2 minutes. During that time ...
ThomasDB's user avatar
0 votes
0 answers
51 views

postgres: shared_buffers vs RAM

I picked up a rule of thumb for setting up shared_buffers depending on max_connetions. I am just not sure which of those 2 caculations was meant 1.shared_buffers + max_connections * work_mem <= ...
vrms's user avatar
  • 175
1 vote
2 answers
74 views

When can we downsize Azure Virtual machine for SQL Server?

For now our production SQL Server is Standard_D96ds_v5 Azure VM machine. We got request to check if we can downsize server to Standard_D48ds_v5. What measures will take into consideration to have ...
adam.g's user avatar
  • 335
2 votes
0 answers
87 views

SQL Server High memory at startup

I have Microsoft SQL server 2019 installed on my Windows Server 2019 server. The memory on the server is 512 GB. When the MSSQLSERVER service starts, MS SQL 2019 immediately consumes 100 GB of memory ...
PetroIvanov's user avatar
0 votes
1 answer
85 views

MySQL NDB Cluster Community - High memory utilization by mysqld only on source/replica nodes

I have two MySQL NDB community clusters 8.0.30, each with 3 VMs Cluster#1_VM1: mysqld + ndb_mgmd Cluster#1_VM2: mysqld + ndb Cluster#1_VM3: mysqld + ndb Cluster#2_VM1: mysqld + ndb_mgmd Cluster#2_VM2: ...
Marcin Stolzmann's user avatar
0 votes
2 answers
103 views

Reducing the number of MySQL processes to save memory

I have just started the MySQL server on my Ubuntu machine, and I see this in htop: There are many mysql processes, each of which takes 4.2% memory. Since I am short on memory, I would like to reduce ...
Erel Segal-Halevi's user avatar
0 votes
1 answer
30 views

MSSQL 2019 CU16 on Linux: virtual_address_space_committed_kb vs RSS

I am running SQL Server 2019 CU15 on Linux in kubernetes and trying to investigate why SQL Server pod gets killed by OOMKiller. I see some inconsistency in reporting of memory consumption. SQL Server ...
Oleg Lavrov's user avatar
0 votes
1 answer
1k views

Error message from server: ERROR: invalid memory alloc request size

I am running with the below issue while taking pg_dump(PG14) of a table with bytea column. pg_dump: error: Error message from server: ERROR: invalid memory alloc request size 1460154641 The command ...
Sajith P Shetty's user avatar
0 votes
0 answers
43 views

Why MongoDB getting higher memory usage?

This is the sample Python code that I used to write data in MongoDB database. After every connection close, I restart the program and I noticed an accumulation in memory count in the Task Manager. ...
Thiwanka Gunasinghe's user avatar
3 votes
3 answers
971 views

MySQL 5.7.42, Gradual memory growth over time, memory leak?

I'm currently running a MySQL server (version 5.7.42) in production, and I've noticed a gradual increase in memory usage throughout the day. I suspect there might be a memory leak issue causing this ...
George's user avatar
  • 31
1 vote
1 answer
763 views

How to release SSAS memory without forcing restart

We have a production server with two SSAS instances, 1 for user querying and 1 with empty templates where we do new releases and (full) processing of the cubes (and then backup and restore processed ...
DBHeyer's user avatar
  • 11
-1 votes
1 answer
252 views

Configure systemd to gracefully restart when memory is almost full

I changed my database to another server, same settings, everything equal, but it seems this new server the memory usage is always close to 100% in less than 2 days (128GB RAM) and I can't upgrade it ...
Freedo's user avatar
  • 188
0 votes
1 answer
565 views

How to Check if SQL Server is Running Out of Memory or CPU Resources RIGHT NOW?

I recently noticed an error message in my SQL Server error log that said "The query processor ran out of internal resources and could not produce a query plan." I suspect that my server ...
Fajela Tajkiya's user avatar
0 votes
1 answer
135 views

Difference between current_allocation s total_allocation in MySQL sys.memory_by_thread_by_current_bytes

I'm trying to debug a memory leak in MySQL 5.7.37 and running the following query gives me insights about the threads running and the memory allocation for each thread. select * from sys....
Sri's user avatar
  • 101
1 vote
1 answer
424 views

PostgreSQL uses huge amount of memory

When executing a query containing WITH and more than a thousand UNION ALL, PostgreSQL version 14 or higher uses all server memory until it enters recovery mode. In tests with version 11, this behavior ...
Rafael Chielle's user avatar
0 votes
1 answer
581 views

MySQL | Measure overall query cost (performance, cpu usage, memory usage)

The Problem You have a MySQL query, let's say a SELECT and you need to identify its overall cost in all aspect (Host Resource Usage, Query speed / performance ...) so that your result can be ...
Federico Baù's user avatar
0 votes
0 answers
534 views

How to minimize risk of ORA-04031 unable to allocate (n) bytes of shared memory across a wide footprint

I monitor thousands of databases that other DBA teams personally manage, and it seems every day there is a one or two databases, usually non-production, throwing "ORA-04031 unable to allocate (n) ...
Paul W's user avatar
  • 578
0 votes
1 answer
58 views

What is a good test command to cause Postgres to use/fill shared_buffers?

I am doing testing on a replica, trying to diagnose why servers take several minutes to shutdown when fast mode is used. It seems to correlate with high shmem usage, can anyone recommend a good query ...
Gregg Leventhal's user avatar
1 vote
1 answer
791 views

how to prevent out of shared memory error when refreshing materialized views

Postgresql14, Windows server 2012 I get an out of shared memory related to a insufficient max_locks_per_transaction. I have two tables: tbl1 has insert/update every night. These actions trigger a ...
Leehan's user avatar
  • 207
2 votes
0 answers
136 views

MySQL release memory allocated for a temp table

I'm using 5.6 MySQL database to insert tens of millions records between multiple tables. Before the insertion I send all my data into a temp memory table, for that reason I have increased both ...
Maksim Vi.'s user avatar
1 vote
2 answers
707 views

What can I do about "maximum memory usage reached (...), cannot allocate chunk of 1048576" in Cassandra?

I got this error: maximum memory usage reached (536870912), cannot allocate chunk of 1048576. I have increased the file cache to 1024, but I still get the error related to memory usage. What can I ...
Moorghen Lutchmanen's user avatar
0 votes
2 answers
61 views

SQL 2016 Server OS Memory - when the total physical memory is 1.5TB

We are looking into virtualizing a large SQL server. The virtualization would not support 1.5TB and the current server is well overspeced in relation to memory, so we are looking at reducing the ...
Mike Fleming's user avatar
0 votes
0 answers
69 views

MySQL or MongoDB, which is more costly and by how much?

I have a dataset of 5 million customers where READ is the most critical operation (avg READ would be 100K rows every half hour). Each customer record contains typical personal information. What are ...
Eran Betzalel's user avatar
2 votes
1 answer
678 views

MySQL consumes much more memory than configured in innodb_buffer_pool_size

Long story short: I have the buffer pool size = 40G. I have 64GB RAM on my server. But MySQL actually uses 73G of memory (53G physical and the rest swapped). MySQL version: 8.0.22-0ubuntu0.20.04.2 ...
Stalinko's user avatar
  • 181
0 votes
1 answer
147 views

Free memory counter in PerfMon

Just want to make sure I am understanding this correct. Say I have set my maximum server memory according to best practice. Now I see in the the PerfMon counter: SQLServer: Memory Manager - Free ...
xhr489's user avatar
  • 805
-1 votes
1 answer
2k views

Postgres server uses all of RAM and SWAP

The Postgres Server Uses all of 120GB RAM and all SWAP! Is there anything wrong? How can I fix this? This is postgres config shared_buffers = 30GB work_mem = 24MB # It's limited for the ...
rostamiani's user avatar
0 votes
1 answer
251 views

mysqli_fetch_array exceeds memory

I a running a relatively simple query: SELECT gb2_designs.indx, gb2_designs.response_required, gb2_designs.user_design_name, ...
rob boudrie's user avatar
0 votes
1 answer
138 views

How do SQL Server allocate RAM for Job steps?

I am working with SQL Server 2016 and SQL Server 2019 Standard edition. We have this job that's been there for a while. It used to be small but now it runs dozens of SELECT/DELETE statements. (There ...
Danielle Paquette-Harvey's user avatar
0 votes
2 answers
192 views

Better estimating "worst case memory usage" for MySQL

Tools such as MySQLTuner add up globally allocated memory and add it to the product of max connections and per connection memory requirement. I formulated the following query to better estimate how ...
Shahid Thaika's user avatar
2 votes
1 answer
6k views

sql server max memory ideal value best practice

Microsoft SQL Server database is running on the live server and the max memory value is 2147483647 by default. There is no problem in this way, but how far can I lower this value to be more ideal and ...
kadocolak's user avatar
0 votes
1 answer
1k views

I have to restart MySQL to lower the CPU usage

I migrated my server to a new Rocky Linux 9 server and since then, my MySQL server of a web server takes almost 100% of CPU after few hours of use. For now the only way I have found to reduce the CPU ...
London Smith's user avatar
0 votes
2 answers
262 views

Oracle change in PGA resulted in Memory problem

We have Oracle 12c at a Windows Server 2012. PGA memory was: show parameter pga; We changed it to: After 5 days, the Memory increased and eventually the system was down, both the application and the ...
eathan's user avatar
  • 23

1
2 3 4 5
16