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
22
votes
2answers
2k 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
35 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
63 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
60 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
78 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
71 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
86 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
44 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
15 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
27 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
57 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
79 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
84 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
49 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
37 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
205 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
195 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
355 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
32 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 ...
1
vote
1answer
30 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
62 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
116 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
12 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 ...
3
votes
1answer
362 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
35 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-...
3
votes
1answer
163 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
50 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
343 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
31 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
83 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 ...
1
vote
1answer
237 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
60 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
106 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
14 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
34 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
35 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
55 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
1answer
40 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
498 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
964 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
224 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
44 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
316 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
28 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
451 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
354 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
80 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. ...