Solved

sql server takes more memory

Posted on 2010-08-26
12
409 Views
Last Modified: 2012-05-10
Hi,

I am noticing on VPS that SQL Server is taking more memory and not releasing memory even when there is no much activity. Is there any method so I can release memory when it is not required,. Either by setting with SQL Server or by programming.

I used memory limit of sql server, but it created problem. I am not willing to go with memory limit.

Thank you
0
Comment
Question by:mkk39
12 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 175 total points
ID: 33529113
> and not releasing memory even when there is no much activity.
this is normal. it takes really some time (hours) with 0 activity until sql server would release memory.

>Is there any method so I can release memory when it is not required,
why that, actually?

>I used memory limit of sql server, but it created problem.
what limit did you set (vs how much memory do you have), and which problem did it create?

0
 
LVL 5

Expert Comment

by:ThakurVinay
ID: 33529180
This all is normal. are you facing any issue, if not let it be :)

thanx
vinay
0
 
LVL 2

Assisted Solution

by:Gk
Gk earned 100 total points
ID: 33531190
There s a maximum memory use settings in SQL server. Pls set it to solve this issue.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 5

Assisted Solution

by:sindhuxyz
sindhuxyz earned 225 total points
ID: 33609909
0
 

Author Comment

by:mkk39
ID: 33613602
This is really helpful
0
 
LVL 5

Expert Comment

by:knowlton
ID: 36107718
I've requested that this question be deleted for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 36107719
I have to object.

sql server will grow to "max memory setting", normally. this is fact.
sql server will reduce below it's used memory ONLY if there is no (very low) activity, and other applications are requiring memory

if you set max memory too low, sql server will become slow as a turtle
if you set max memory too high, sql server + os will become slow as turtle

if you run too many apps on the same "server" (aka sql server + other apps), you have to tune the memory usage.

nothing "complex"
point split
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 36158686
I suggest point split for 4 first comments
0
 

Expert Comment

by:Modalot
ID: 36199733
Following an Objection by angelIII, and after Moderator review, there seems to be a better  disposition, as recommended by the contributing Expert(s).

Modalot
Community Support Moderator
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Call windows 10 virtual keyboard from windows forms app 2 35
Hey!!!! 1 20
Help with exporting to excel 4 27
Expression Evaluater 3 25
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question