All Questions
Tagged with sql-server-2017 memory
15 questions
7
votes
1
answer
3k
views
Memory Requirements for SQL Server
We have a machine with 256 GB RAM.
Max server memory for the SQL Server is set to 180 GB.
Out of 180 GB, SQL Server typically uses:
Database Cache memory - ~ 140-150 GB
Plan Cache - ~ 10 GB
Stolen ...
- 5,964
0
votes
2
answers
73
views
SQLCONNECTIONPOOL growing very huge
One of my db server SQLCONNECTIONPOOL growing very huge,it consumed 55GB , out of 65Gb (sql MAX) memory)
Environment: Microsoft SQL Server 2017 (RTM-CU25) Standard Edition
How can i reduce the ...
4
votes
2
answers
11k
views
SQL Server 2017; Memory troubleshooting; There is insufficient system memory in resource pool 'internal' to run this query
We are running a local SQL Server 2017 to support a datawarehouse database. The database is loaded on a schedule through SSIS largely through the use of staging tables and the MERGE function. Recently,...
- 158
0
votes
3
answers
776
views
How Important is the buffer pool really?
I have been doing some testing of a new (virtual) server which is to replace an existing production server. We suspect the current production server is overspec'ed and therefore are tweaking the ...
- 2,083
0
votes
1
answer
576
views
SQL Server high SQLCONNECTIONPOOL consumption
SQL Server Version : SQL Server 2017(RTM-CU21) on Linux
Runing environment : kernel 4.19,Docker 18.09
Docker Image : docker pull mcr.microsoft.com/mssql/server:2017-CU21-ubuntu-16.04
Problem ...
2
votes
0
answers
470
views
Some SQL Server memory consumers keep stealing memory from "Total Server Memory" ? It keep decreasing without any external memory pressure
Problem Description : SQL Server Memory Usage keep increasing while Total Server Memory keep decreasing till ERROR: fail_page_allocation accoured and instance crash
Version : SQL Server 2017(RTM-CU21) ...
-1
votes
1
answer
49
views
How can I figure out what the minimum MaxMem value could be without causing issues. MSSQL 2017 Enterprise CU18
I am running several 2017 CU18 instances in failover clusters with "standby" instances for planned growth. I want to configure those standby instances with the least amount of RAM (lowest ...
- 39
2
votes
1
answer
262
views
Reason why SQL Max memory expansion seems slow when migrated to newer version of SQL server
We are trying to understand below behavior happening in SQL Server and need some guidance:-
After migrating from older version SQL2012 (running on bare metal P Server) to newer SQL2017 running inside ...
- 794
0
votes
1
answer
11k
views
MEMORYCLERK SQLBUFFERPOOL
SQL Buffer pool is consuming more memory in sql server 2017. Is there any way to reduce it??
or How can we find what is consuming more? We are receiving alert for low buffer cache hit ratio.
...
- 161
10
votes
4
answers
7k
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] = ...
- 131
0
votes
1
answer
4k
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 ...
- 5,964
1
vote
2
answers
590
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 ...
- 5,964
7
votes
2
answers
4k
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, ...
- 5,964
0
votes
0
answers
59
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 ...
- 111
6
votes
1
answer
2k
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 ...
- 165