Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

6
votes
0answers
118 views

SQL dumping all pages from buffer cache every few minutes

I have a single SQL2012 SP4 node running several databases. The server has 20GB of memory available, 14GB allocated to SQL (nothing else running on the box). Every few minutes SQL dumps the whole ...
0
votes
1answer
39 views

MySQL is not releasing memory after memory tables are dropped

After creating several tables of memory engine and dropping them, mysqld is not releasing all the corresponding memory. Below are the exact steps to reproduce the problem. Memory usage is observed ...
2
votes
2answers
114 views

Unexpected RAM usage on MySQL

We have a server which hosts about 10 customers in a multi-tenant web application, each customer has its own database which is cloned from a template, and each database is a little less than 3000 ...
2
votes
1answer
28 views

High number of Checkpoint pages/sec and memory pressure

Recently I read a blog post on mssqltips.com about memory bottlenecks on SQL Server. In this article I read following: The following performance counters on SQL Server: Buffer Manager object can ...
0
votes
1answer
32 views

PostgreSQL. Shared_memory and sessions

I have a standalone server which is running Jira and PostgreSQL 9.6. I have noticed that PostgreSQL has shared_buffers parameter is equal 128MB where RAM is 32GB. Because server is shared with ...
0
votes
1answer
129 views

ORA-27102: out of memory

We're facing an Out Memory Problem with an Oracle database SE 12c Release 1 (deployed as a Docker container) ... The only information that I have is this one: Caused by: java.sql....
2
votes
1answer
87 views

Availability Group cluster memory issue after network issues. How to dump HADR Log Block Msg Pool?

We have a four node Availability Group, two nodes in one site, two nodes off site in another data center. I have noticed after every WAN issue where the WAN connection is flapping, and the off site ...
1
vote
1answer
52 views

How does SQL Server determine how much memory to allocate to Data cache

SQL Server Standard Edition has a limit to how much memory it can use for the data cache. With that in mind, how does Enterprise Edition decide how much memory it can use for the data cache? Lets ...
0
votes
0answers
150 views

PostgreSQL - pg_dump fails (out of memory) - queries to a table fail for memory

Version: PostgreSQL 9.2.1 - 32-Bit Windows We have a database which is fairly small (~1.4GB) that is unable to be backed up. It seems to fail on the same table (attachment_data - has about 3500 rows)...
0
votes
1answer
39 views

System memory behavior during huge mysql import

I am importing a huge (~900GB ) dump in a mysql 5.5 server; The system has 48GB of RAM. Here are my InnoDB settings innodb_read_io_threads = 16 innodb_write_io_threads = 16 #To ...
1
vote
1answer
81 views

SQL Server Not Consuming all Memory - Insufficient System Memory in Resource Pool 'internal'

I am running SQL Server Standard 2014 with SP3. I am noticing a lot of activity on the log viewer around insufficient system memory in resource pool and memory Broker. I have searched on this error ...
1
vote
1answer
79 views

Memory distribution across numa nodes within Sql server

I need to understand following behavior of memory distribution across numa nodes within sql server Current set up: 2 node cluster SQL server 2014 SP2 with virtualization disabled We have 4 NUMA ...
1
vote
1answer
68 views

Strangely high writes per second

I'm experiencing some extremely strange behavior on one of our OLTP Servers. Just to provide a bit of background, we have an 'OLTP' which has many large and wide tables. We have 560 tables within it ...
1
vote
1answer
72 views

sql server cache clock hands

I'm doing some research about how to troubleshoot local memory pressure. Correct me if I'm wrong but as I understand it is that SQL Server uses a CLOCK algorithm for the cache- and userstores. Each ...
0
votes
1answer
161 views

MySQL consuming too much memory

Version : mysql Ver 15.1 Distrib 10.3.9-MariaDB OS : CentOS Linux release 7.5.1804 (Core) Specification : 384GB RAM Context : I am using this server only for database (with no other processes ...
3
votes
1answer
240 views

Memory Pressure in SQL Server - Enable LPIM or not?

I have slow query execution in my SQL Server 2016. Server configurations: Total Physical Memory : 128 GB SQL server Max Memory : 102 GB Transaction replication is enabled. Database Size:1.6 TB ...
2
votes
1answer
148 views

Using Resource Governor and allocate more memory to satisfy high Memory Grant request by queries?

On a SQL Server 2016 database server, I have few queries which are really slow and which ask for more memory (queries are not optimized). This is making the whole database slow as lots of users are ...
2
votes
2answers
218 views

MySQL Performance vs. Memory

We are running MySQL Ver 5.7.18 on an Amazon Lightsail Linux instance (2GHz Single Core CPU, 2GB RAM, 40GB SSD). Besides MySQL, we also run some Java services on this machine, which access the ...
1
vote
1answer
173 views

Slow Query with RESOURCE_SEMAPHORE wait info [closed]

Hi I see lot of RESOURCE_SEMAPHORE as wait_info when i run sp_whoisactive in my sql database server.I see few CXCONSUMER as well.I learned that CXCONSUMER is because of parallel query execution.How to ...
0
votes
1answer
86 views

Oracle 11g: increasing buffer cache with AMM

On a 2-node RAC we have enabled Automatic Memory Management. The advisor views indicate that increasing the buffer cache by 4 GB will half the physical reads, and we have 4 GB to give. How must we ...
1
vote
0answers
10 views

oracle 11g: increasing buffer cache with AMM [duplicate]

On a 2-node RAC we have enabled Automatic Memory Management. The advisor views indicate that increasing the buffer cache by 4G will halve the physical reads, and we have 4G to give. How must we do ...
2
votes
1answer
102 views

Always On Setup - OBJECTSTORE_SERVICE_BROKER Memory clerk eating all the memory

We have an Always On setup where in we have two secondary replicas to our primary replica. One of the secondaries is placed in the same datacenter as the primary and the other one is placed at a ...
1
vote
2answers
73 views

Memory threshold is attempted on SQL Server

Currently we have a monitoring for all the infrastructure (server, DB, network components, etc ...). The alert thresholds, usually saturation, are configured as follows: 90% : Warning 95% : Critical ...
1
vote
0answers
319 views

MySQL memory usage is too high - OOM

Im using 32vCPU and 120GB VM for Mysql 5.6. it's a dedicated MySQL server. 15000 IOPS SSD disk. Total database size 40G This server was working fine for a couple of months. Memory usage is ...
1
vote
1answer
40 views

Monitor RAM/Memory

I'm planning to create a job that automatically gets the status of my server's RAM/memory at the time of the job's activation. My job has the command: use master insert into Rec.dbo.MemoryRec ...
1
vote
1answer
363 views

What does “Failed to allocate BUFs: FAIL_BUFFER_ALLOCATION 64” in the SQL Server Log mean?

Every once in a while, I see the error Failed to allocate BUFs: FAIL_BUFFER_ALLOCATION 64 in the SQL Server log. Oddly this seems to get thrown at off hours where there is no job or backup ...
1
vote
1answer
311 views

Oracle 12c Database swapping after set up huge pages

I need to setup a Oracle Database 12c with 64GB RAM on Linux RedHet. I decided to use huge pages. Something must have went wrong. Altertlog: WARNING: Heavy swapping observed on system in last 5 ...
1
vote
2answers
399 views

MySQL consuming memory, seeking advice on how to configure it

I have a small VPS that handles my 3 personal WordPress websites. At a certain time MySQL started consuming more and more memory and actually (for months) the server has been running at 99% RAM usage ...
1
vote
2answers
239 views

How to grant more memory to run R processes in SQL Server 2016 R Services

I'm running a fresh install of SQL Server 2016 Standard Edition (13.0.5026.0) with R Services on Windows Server 2016 Standard. With all sorts of happiness I went to run an R script that completes ...
3
votes
2answers
620 views

System Monitor and Memory in SQL Server

Which performance counter (System Monitor) should I use to answer the questions: total amount of memory currently used by SQL Server total amount of memory used by a process total amount of memory ...
2
votes
4answers
6k views

Memory Usage by SQL Server

How do i check memory usage by my SQL server in production box. I am using SQL Server 2016.When ever i check task manager,it shows above 90%. I don't think that is the real memory usage by sql server. ...
-2
votes
2answers
541 views

How to query system specs (cpu, memory, data disks, free space) using t-sql [closed]

Is there an ability to query below system specifications using t-sql ? 1. cpu (show number of processors / cores / frequency) 2. memory (show total amount of RAM on a machine; show allocated RAM; ...
1
vote
2answers
404 views

SQL Server switched to use pagefile exclusively instead of RAM and effectively froze the world

I was hammering my SQL Server instance yesterday for about 3 hours running an intensive calculation which was consuming all allocated physical RAM (I have it limited to 2GB due to my limited ...
3
votes
2answers
58 views

MySQL 5.7.21 not releasing memory after writing partition to disk

I've been testing extracting with SELECT * from a partition in a partitioned table in MySQL 5.7.21 and 5.7.22 I'm out of ideas and hitting my head on a wall. The goal is to write the data to S3 for ...
1
vote
3answers
430 views

Why is SQL Server only able to grab 1Gb of memory?

Running SQL Server 2008R2 STD 64bit edition on Windows 2008 R2 64 bit edition. The Windows server is a Hyper-V VM with its memory set as follows When I run the following query; SELECT [...
0
votes
3answers
86 views

SQL Server memory benchmarking - how to fill up memory?

Recently I was asked by my VMWare colleague how to cause a (non-production and bare install) SQL Server to use up the memory of a machine. The solution I found in this forum post does not cause the ...
2
votes
2answers
430 views

Postgresql large transaction OOM killer

We have a Postgresql 9.5 running on CentOS release 6.5 (Final) The server has 16GB of ram. We are running a long transaction which adds and updates 10s of millions of rows in multiple tables. Besides ...
3
votes
1answer
111 views

SQL Server's Buffer Cache Size steadily decreasing

We have been having an issue with SQL Server where the buffer cache size decreases over time to the point that we have to restart the service to free up the memory. It gets low enough that is ...
38
votes
3answers
4k views

SQL Server's “Total Server Memory” consumption stagnant for months with 64GB+ more available

I have run into an odd issue where SQL Server 2016 Standard Edition 64-bit has seemed to have capped itself off at precisely half of the total memory allocated towards it (64GB of 128GB). The output ...
3
votes
1answer
460 views

SQL Server not using all NUMA memory with 20 core limit and affinity mask

I have a physical SQL Server 2016 SP1 machine with this spec: CPU Sockets: 2 Cores per socket: 44 Multithreading: Yes Number of cores: 88 RAM: 256 GB SQL Server Max Memory: 240 GB ...
2
votes
0answers
179 views

SQL server never uses all the memory

I have 1 TB Dynamic Axapta DB on the SQL Server 2012. I have 128 gigabytes of memory. Version : Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) Oct 19 2012 13:38:57 Copyright (c) Microsoft ...
3
votes
1answer
277 views

Give a “super” user more work_mem

One common pattern I’ve noticed over the years is that people tend to keep increasing working memory as their data size increases, so that more complex queries can still take full advantage of memory ...
0
votes
0answers
960 views

Oracle 12c - Minimal memory configuration

I've installed the Oracle 12c v12.2.0.1 EnterpriseEdition on my Windows7 development notebook (because I need some features that are not available in lower editions). I installed it with the ...
0
votes
1answer
81 views

Optimal Hardware for > 30K Requests / min? [closed]

We have some performance issues with one of our Test-Machines a MySQL 5.7.21 Standalone Server. We have: 8 CPUs 16GB RAM (buffer_pool_size 5.6 G) and need to handle > 30 K Requests / minute. When ...
1
vote
1answer
306 views

Check current memory_limit of Replication Server version 15.7.1

Does anyone knows how to check the currently memory_limit of replication server? I need to increase the memory_limit of my replication server, but I couldn't check the current memory limit. Can anyone ...
1
vote
1answer
72 views

Decision concerning RAM limit

What steps would you do to be sure that STANDARD edition with its 128GB RAM limit is enough for your production? My subjective feeling is that we are somehow on the edge and I am looking for strong ...
1
vote
1answer
52 views

Special Considerations for SQL Server with 512 GB RAM / 64 Cores?

Apart from some Windows Hotfixes are there any special considerations (i.e. "things to worry about") when running SQL on a server with 512 GB RAM and 64 logical cores? I'm aware of some guidance when ...
5
votes
1answer
238 views

How to limit work_mem on PostgreSQL

As an analyst I love having the ability to turn up the work_mem on occasion when a big sort or index build is in the offing. As a DBA, the idea of random users being able to request an arbitrarily ...
1
vote
1answer
701 views

Do I gain read performance improvement by using zlib rather than snappy compression in MongoDB?

My current storage engine is WiredTiger and its compression level is as default, snappy. I've come across MongoDB documentation and it's been mentioned that using zlib compress better but needs more ...
2
votes
0answers
60 views

Is it correct to get SQL Server read write ratio from sys.dm_os_buffer_descriptors?

I'm reading a book and the author taught us a trick to calculate the read write ratio by using sys.dm_os_buffer_descriptors. I suspect the correctness of this method. After a page has been read into ...