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.

0
votes
0answers
11 views

Lock pages in memory for system accounts

Yes, well where to start? If you really enjoy installing and fine-tuning Microsoft SQL Server or Oracle RDBMS instances on Microsoft Windows Server, then at some point you will all come across the ...
1
vote
2answers
25 views

How to determine if it is necessary to increase the sga and the pga in Oracle database

How to determine if it is necessary to increase the sga and the pga in a database oracle 12c, is there any procedure, any specific view where can I be guided that indicates to me that it is necessary ...
7
votes
2answers
105 views

Increase Max Memory setting on a SQL Server Production

I have a production box with 5 instances on. Version: SQL Server 2014 SP3 Enterprise. I discovered that even though the machine has ~400GB memory assigned, the combined MAX MEMORY settings on all 5 ...
-3
votes
0answers
22 views

How to configure settings to release SQL server allocated RAM memory when it is unnecessary [duplicate]

I hosted application and database in a same server. And i have one of large execution process by job in mid night. After that server RAM memory fully allocated to SQL server and not going down. And ...
0
votes
0answers
31 views

drop_cache effects on database

I have several machines with: databse: db2 10.5 OS: CentOS 6.9 on some of machines cached memory is high and i need to run this command to free some memory: echo 3 > /proc/sys/vm/drop_caches ...
1
vote
2answers
193 views

Target/total memory is higher than max_server_memory

I have the max_server_memory setting configured to 141 GB on our production SQL Server and target/total server memory is 144 GB. I thought max_server_memory represents how much memory I am willing to ...
0
votes
1answer
22 views

Using AMMM or Huge Pages for Oracle 11g R2 Database

I'm running an Oracle production 11gR2 database which has around 65Gb of data, running with a 4Gb SGA & 40Mb PGA using ASMM. Now, I have a memory increase up to 32Gb. I'm planning to increase ...
6
votes
1answer
162 views

Why SQL Server Standard 2017 is using more memory than limit described in documentation?

Documentation says: For example: A Standard Edition of SQL Server has buffer pool memory limited to 128GB, so the data and index pages cached in buffer pool is limited by 128GB. Starting with ...
2
votes
2answers
101 views

SQL Server Internal Memory Error

I am using SQL Server 2016 Standard Edition that shows the following errors on DBCC CHECKDB and also on updating statistics. Version: Microsoft SQL Server 2016 (SP2-CU2) (KB4340355) - 13.0.5153.0 (...
1
vote
1answer
61 views

Linux SQL Standard Edition being killed by OOM killer

We have launched Linux with SQL Server standard edition for production environment, but the memory restriction feature in SQL Server is not working properly. The server has a total of 32 GB of RAM. ...
1
vote
3answers
155 views

Estimate query speed for +1.5 billion rows mysql table

I'm working on audio fingerprinting problem where I need to query a very large table in terms of number of rows (at least 1.5 billion rows), but relatively OK in size (23G), and retrieve about 50K to ...
0
votes
3answers
101 views

Configuring the max_connections setting in MySQL

I've gone through a number of docs and forums but can't quite find the right answer for how to determine the number of maximum connections I should set. I tried using MySQLTuner, that gave me: ...
1
vote
1answer
52 views

32-bit Enterprise SQL 2005 on 64 bit Windows 2008 Server Standard. Memory configuration

Working on a project we need to first stabilize and then upgrade. We have a 32bit Enterprise edition SQL Server 2005 installed on a 64 bit Windows 2008 standard Server. The server has 64GB RAM ...
8
votes
1answer
177 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
113 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
124 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
64 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
37 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
461 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
105 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
59 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
263 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
77 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
210 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
115 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
2answers
103 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 ...
2
votes
1answer
96 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
299 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
337 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
185 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
425 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
224 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
140 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
125 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
83 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
398 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
45 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
500 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
500 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
465 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
293 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
887 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 ...
3
votes
4answers
11k 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
753 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
553 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
88 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
510 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
99 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
569 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 ...