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
1answer
19 views

Manually trigger “Write current results to disk” during query

Using PostgreSQL 12, I have the requirement that some data needs to be "refreshed" each night. That means: The database has to do some calculations based on the current date and write the result to ...
4
votes
2answers
1k views

Memory utilization by SQL Server

I m using SQL server 2012. I have a stored procedure that will eventually be tuned, but I have one question. My server memory is 32 GB and max memory assigned in SQL Server is 20GB. When I execute ...
0
votes
0answers
28 views

SQL server working set vs commit memory [closed]

I've noticed a general degradation in SQL server performance last night and the first thing that I've noticed is that a sqlsrervr.exe process states that Working Set memory is only 790ish MBytes and ...
1
vote
1answer
81 views

Slow query time after upgrade to MySQL 8.0.20

I apologize in advance if a similar question has been asked. I've been digging through Google and StackExchange trying to find an answer but now I'm stuck and stumped. I am still relatively new in ...
0
votes
1answer
23 views

Is it possible to detach some specific database from MongoDB Server?

I have to keep several copies of production databases serving by a dockerized MongoDB server. I do NOT want to backup, then to drop, then, when I need it again, to restore it. It is not as quick ...
0
votes
0answers
7 views

MemoryError with django app

I develop a django application with Postgres. On my local host where I develop the app, I use ./manage.py run to launch my app and it works successfully even with queries that produces huge output. ...
0
votes
2answers
44 views

Cannot lower/figure out per connection mariadb memory usage

I'm running a small mariadb DB to serve some websites and monitoring tools (nexctloud, wordpress and icinga2). The machine that works as a DB server also run an elasticsearch + graylog instance so I ...
0
votes
0answers
33 views

PostgreSQL: “PANIC: out of memory”

Got an error while running an application connected to a PostgreSQL DB (10.12). All the connections got disconnected, looking through the server logs, I found the below. TopMemoryContext: 292488 ...
4
votes
1answer
212 views

SQLServer 2016 continually increasing stolen memory

We are experiencing a slow growth of Stolen Memory on our database servers over the space of several days. It appears to plateau around 130-140GB, at which point we start having larger problems such ...
1
vote
1answer
111 views

Setting MAX memory for SQL servers depending upon the model of CPU

I have a general question regrading setting up the MAX SQL memory settings- For our current CPU with below specs, server team bumped up OS memory from 400GB to 1TB: Intel® Xeon® Processor E5-4640 v2 ...
0
votes
0answers
43 views

Why would a very simple Oracle query use a large amount of shared memory?

I have a very simple query which is as follows: SELECT blob_column, varchar2_column FROM table WHERE number_column = ? AND code_column = ? This will find one row by the primary key. This shows as ...
0
votes
0answers
31 views

sqlcmd returns Msg 701 when importing +10MB queries

I have a powershell script that exports data from DBF files, saves them as .SQL files and then imports the SQL files into MS SQL 2016 using the sqlcmd command. There's one SQL file per table in my ...
2
votes
1answer
30 views

Is there a memory overhead using partitions in postgres vs. a single table?

Background I am ingesting time series data totalling to about 10M rows per day, where each row has a timestamp, a player id and some other columns. That data is then queried via an API for a ...
0
votes
2answers
54 views

Percona XtraDB Cluster (5.6.28-76.1-56-log) - random OOM events

We have a multi-node (each of 64G RAM) cluster. The main (the one we use for mutating data) node randomly just OOMs, this happens both in peak times and in extremely quiet times. What we've noticed ...
4
votes
0answers
108 views

SQL Server 2019: Memory performance with graph queries (possible memory leak)

I'm currently working on implementing an upgrade to SQL Server 2019 in order to make use of the graph features that are available in it. Our database stores records of files and their children, and ...
2
votes
1answer
78 views

SQL Server Memory Performance

I have two instances in one server. I configured the max memory with the same number on each instance. Total 36 Gigs and I gave 17 to each. Why the target memory keep coming up and down on one ...
2
votes
3answers
108 views

Weird memory pressure for SQL Server 2016

We have been battling an issue with weird memory pressure on a specific server for a couple of months now. Here's what the last incident looked like in SentryOne: System Memory SQL Server Memory ...
-1
votes
1answer
24 views

MySQL - Which options in the configuration file have an impact on memory usage?

I've been wondering how to manage MySQL memory usage since by default it takes up to 350MB while idle on my machine, I don't have memory issues, I honestly just wondered how could it be done. I found ...
1
vote
1answer
86 views

How memory allocation happened in SQL Server

Suppose I have a 32 GB machine, now I have allocated 12GB memory to the maximum server memory for my database application to perform. Now I am running some load simulation which is going to consume ...
4
votes
1answer
197 views

Changing to compatibility level 150 makes SQL Server consume all available memory

We're moving an existing DB to a new SQL Server 2019 instance. If we change the compatibility level to 150, nothing works. Task manager shows that sql server service is consuming all available ...
9
votes
4answers
2k views

Increased memory to server, but do I need to change page-file size?

I'm running SQL Server 2017 on Windows Server 2012 R2 and have increased the memory from 256 GB to 512 GB. I've noticed the following configuration for Virtual Memory: C: [OS] = 2 GB G: [DATA] = ...
3
votes
1answer
80 views

When were there changes in the memory settings of SQL Server

Is there a log, query or any other way to see when there was a change made to the memory settings of SQL Server?
0
votes
0answers
25 views

Is there a way to access the LRU information in SQL Server Buffer Pool? [duplicate]

In SQL Server (2017) you can find all pages that are loaded into memory, and the page life expectancy etc. But is there a way to see the last time a page in the pool was actually read? The process ...
1
vote
1answer
83 views

PostgreSQL runs out of memory in the middle of query

I am running a PostgreSQL 11 database in AWS RDS in a db.t2.xlarge instance (4 CPU 16 Gb RAM) with 4 Tb of storage. My query is based on a fairly large table (48 Gb -- 243.711.955 rows), but nothing ...
33
votes
2answers
4k views

Is it generally faster to select into a temp table than selecting into an actual table?

I thought I once read somewhere that writing to tempdb is faster than an actual table not in tempdb. Is this true in any capacity? I thought I recall it saying something special about tempdb and ...
2
votes
2answers
43 views

Virtualized SQL Server hits 100% CPU and 0 Active Memory

We recently experienced an odd crash with one of our server. We know what caused it, but we don't know why SQL Server responded the way it did. SQL Server 2016 Here is what happened: Friday: ...
0
votes
1answer
74 views

Sql Server 2016 uses low RAM [closed]

I have an SQL server 2016, version: (SP2-CU4-OD) (KB4482972) - 13.0.5239.0 (X64) The server is a Win 2016, with 64 GB RAM. I have configured max memory for SQL to 54 GB, but it uses less than ...
3
votes
1answer
61 views

Is Memory Grant size 'cached' for subsequent executions of a cached plan?

I hope the title of the question is clear. I am a DB developer as one of my job roles. I recently asked a question regarding index statistics and I have spent a lot of time reading about statistics, ...
0
votes
2answers
547 views

Best Practice for Oracle SGA and PGA Memory Components Size

I have a Server that has 128GB RAM. I have read here and there that the size of SGA + PGA can bee 80% of the RAM. I wonder if there is any best practice for this configuration that could allow Oracle ...
5
votes
0answers
139 views

What are the downsides of running DBCC FREESYSTEMCACHE ('TokenAndPermUserStore') hourly?

I have been seeing some concerning behavior in the SQL Server memory caches on one of our production servers. We are on SQL Server 2014 SP2 Enterprise Edition, 16 cores, 400GB RAM (300 GB dedicated to ...
6
votes
1answer
91 views

At what point is a (disk-based) table removed from memory after data is read from it?

Are (disk-based, so no Hekaton) tables persisted in memory for longer than the lifespan of the query that is reading data from them? If so, what determines how long they stay in memory for? Is there ...
2
votes
1answer
53 views

Does enabling LPIM work even if the memory pressure is coming from SQL Server itself

I have a scenario where I have 128 GB Physical memory for the SQL Server 2016 machine. It is a SQL Server dedicated machine. I have 110 GB allocated to SQL Server itself. I have performance issues ...
0
votes
0answers
22 views

MySQL 5.1 jemalloc not enabled

I tried searching everywhere to enable jemalloc in MySQL 5.1 but couldn't find any answer. I also tried enabling in my.cnf [mysqld_safe] malloc-lib = /usr/lib64/libjemalloc.so.1 But this ...
0
votes
0answers
29 views

Memory allocation [duplicate]

How could we decide over how much memory will be good enough for a sql server 2012 standard edition instance having only 1 DB of around 250GB and it's very busy database through out the day, having ...
1
vote
1answer
63 views

Do I need to add more memory to my SQL Server 2008 R2 instance?

I've been asked if one of our SQL Server instances has sufficient memory. This is a SQL Server 2008 R2 Standard Edition running on a x64 machine with 40 CPUs and 64 GB of RAM. The total size of all ...
0
votes
1answer
107 views

SQL Server Stolen Server Memory - what it consists of?

Below what my server's performance counters show: Questions: 1) What "Stolen Server Memory" consists of ? I can assume "Plan Cache", "Lock Memory", "SQL Cache", "Connection", "Optimizer" are ...
1
vote
0answers
224 views

Postgresql SUM query giving “cannot enlarge string buffer”

Postgres version is 11.2, dockerized, the default image with pg_activity installed as an extra. OS is Ubuntu server 18.04. Base dockerfile is debian:stretch-slim Call is done via the PostgreSQL JDBC ...
1
vote
2answers
107 views

How to query SQL Server Memory Manager performance counters in DMV?

Is there any system catalog views or DMVs that can be used to query (in SSMS for example) below performance counters from SQL Server:Memory Manager ? Free Memory (KB) Target Server Memory Total ...
6
votes
2answers
2k views

How SQL Server caches data in memory

I have couple of questions on how caching of data works Imagine we have below situation: Server restarted or we just ran DBCC DROPCLEANBUFFERS We have a Table1 that is 50 GB and has columns A, B, C, ...
1
vote
2answers
56 views

Different Maximum server memory across Availability Replicas

I have a scenario in SQL Server 2014 AlwaysOn High Availability where other services are running in one of the Secondary read-only replicas. These services obviously demand additional memory. Is ...
0
votes
1answer
544 views

Memory Settings for SQL Server, SSAS, and SSRS

I started a new job about 4 months back and was surprised to learn that there has NEVER been a SQL Server DBA here, just developers who don't really know what they're doing (like me). I am not a DBA ...
1
vote
2answers
583 views

postgresql pg_dump out of memory

is it possible to limit somehow usage of resources for pg_dump? The problem is, whole DBase is 775GB and i have two very large tables: pg_largeobject table is – 390GB pg_largeobject statistics: ...
1
vote
2answers
465 views

SQL Server RAM usage is increasing and query executions is slowing down with time

I'm using SQL server on a server with 48 GB of RAM. When I start the SQL Server service, it's using 12% of the RAM at first, but after 24 hours it's reaching 90% and query executions begin slowing ...
0
votes
1answer
73 views

Define Database Size

I want to create a database with Size limitation. I am using sql server 2008r2 edition. Maximum size should be only 20GB. That means it should allow only 20GB space for particular database. How can ...
0
votes
1answer
305 views

Failed to create appdomain “master.sys[runtime].2”

I am getting this error in SQL Server log: Failed to create appdomain "master.sys[runtime].2" Could not load file or assembly System.Data . Not enough storage is available to process this command ...
1
vote
1answer
36 views

SQL Server Setup: Report Server and RAM Considerations

DISCLAIMER I am a software developer by trade, but sometimes have to put on my 'dba' hat in the absence of a true dba. SETUP I am working on a project where: SQL Version is SQL Server 2008 R2 (...
0
votes
0answers
35 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
68 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 ...
3
votes
0answers
190 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:...

1
2 3 4 5
13