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
0answers
27 views

SQL Server 2017 not occupying free memory

Recently one of our read servers (SQL Server 2017 CU2 - yes, way out of date) had its Page Life Expectancy drop from an avg of 15K seconds to 250 seconds. It is one of 2 load balanced read servers ...
1
vote
2answers
54 views

SQL Server memory issues after upgrade from Express

I have a SQL Server 2014 Standard (x64) instance that was recently upgraded from SQL Express. The VM that the SQL instance is on has ~16GB of RAM and SQL MAX MEMORY has been configured to use ~12GB ...
2
votes
0answers
84 views

Brand new SQL Server 2016 (SP2/CU1), has high CPU utilization with no mounted databases when the box experiences memory pressure

Brand new SQL Server 2016 (SP2/CU1), has high CPU utilization with no mounted databases when the box experiences memory pressure. I have a test box for nightly builds with a brand new SQL Server 2016 ...
16
votes
2answers
2k views

What happens when there is no available physical memory left for SQL Server?

While googling I found some conflicting information. Some sites state that when there is no physical memory left for data, then SQL Server moves the already existing data into TEMPDB (see: SQL Server:...
0
votes
2answers
9 views

Max Memory setting AWS EC2

we have move some SQL Server from Physical to AWS EC2 - my question is regarding Max Memory Setting fro SQL Server instance - I used to change the memory setting in Physical server giving some to OS ...
1
vote
1answer
88 views

AWS Aurora running out of freeable memory and crashing

We have an issue with our AWS Aurora MySQL instance running out of freeable memory and crashing as a result. AWS's response was to upgrade to a bigger instance, but I don't feel that will necessarily ...
0
votes
1answer
22 views

Should Amazon RDS SQL Server 2017 Web Edition Max Memory settings be different from that of a locally installed instance?

We have an Amazon RDS SQL Server Web Edition on Windows Server 2012 with 2 processors and 8GB RAM. Should I configure the Max Memory similar to that of an instance on a local server i.e keeping back 3-...
2
votes
1answer
20 views

AWS aurora (postgres) proper value for the shared_buffers parameter

I think it's fairly well known that a normal PostgreSQL database has a starting value of 25% of system memory for its shared_buffers parameter, but I haven't been able to find anything regarding a ...
2
votes
1answer
37 views

Postgres memory settings (RAM, work_mem, etc.) for complex text searches on indexed tsvectors

I know very little about Postgres memory settings. I have developed a paid-access database, which mostly stores text (and some metadata) 2 tables have 10 millions rows with little text (1 paragraph ...
7
votes
1answer
232 views

Multiple BIT datatype columns in the same table

Consider the following information coming from Microsoft SQL docs pages: The SQL Server Database Engine optimizes storage of bit columns. If there are 8 or fewer bit columns in a table, the ...
0
votes
1answer
25 views

MySQL server upgrade, how to adapt variables?

I am about to upgrade my MySQL server because I have currently used it mainly with a couple of people in the development stage. Before we launch, however, we would like more capacity to avoid the ...
0
votes
1answer
64 views

MariaDB is not using all memory available

I have a joomla web site with about 160.000 articles. I use 10.4.6-MariaDB, nginx and php 7.3. When I check my server with top, I see a maximum of 3,3 MB of memory usage by MariaDB while I have given ...
0
votes
1answer
91 views

Mysql eat a lot of memory but innodb_buffer_pollsize is set to 50%

I don't understand why my mysql eat a lot of memory even though I set innodb_buffer_poll_size to around 50% here is my top user@Mulia-Abadi:~$ top top - 11:09:31 up 12 days, 16:30, 3 users, load ...
0
votes
1answer
40 views

MySQL using more memory than expected

We recently upgraded a database server from Ubuntu 14.04 to Ubuntu 18.04, and at the same time upgraded MySQL from 5.6 to 5.7. Since the upgrade, the memory usage has more than doubled, from ~10GB to ...
0
votes
0answers
47 views

USERSTORE_TOKENPERM growing very fast

I'm experiencing a very weird problem with userstore_tokenperm clerk recently. We have an environment with some databases in contained mode executing in version SQL Server 2017. Anyway i'm facing ...
0
votes
0answers
12 views

Script to alert me that a droplet resize is necessary for PostgreSQL DB to fit into memory?

I am trying to answer the question, "How big is my PostgreSQL DB relative to memory on my Ubuntu server?" The goal of asking this question is to be able to alert me to when the size of my database is ...
0
votes
0answers
30 views

cx_Oracle high memory use

I am using cx_Oracle with python to select a dataset of about 200,000 rows. I am having memory issues with my application, so I am memory profiling. The memory use for these lines is over 1G, however,...
0
votes
0answers
28 views

Memory usage of large transactions

I have an application which persists itself to a PostgreSQL 11 server. It does this by truncating the tables (removing the old state) and then uploading its current state (many statements) as part of ...
3
votes
1answer
46 views

Understanding Stolen and foreign memory usage between 2 app database servers

Below is more for my understanding on how to interpret the data from my perfmon counters for 2 database servers with diff app structure but sort of similar workload Server A has total of 1 TB RAM ...
0
votes
0answers
24 views

Is it recommended to monthly planned restart MongoDB production server to clean non-mapped virtual memory?

We have a replica set of production mongoDB 3.6.10 , large volume of 5.5 TB , over 10,000 connections anytime , applications read both from primary and secondary servers , we see almost every month a ...
1
vote
2answers
165 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
196 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
159 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 ...
0
votes
0answers
37 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
250 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
24 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
248 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
179 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
75 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
190 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
446 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
59 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
204 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 ...
1
vote
1answer
226 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
242 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
113 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
66 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
2k 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
137 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
91 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
488 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
118 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
392 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
191 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
225 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
134 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
554 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
571 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
250 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
705 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 ...