• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

sql server takes more memory

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
mkk39
Asked:
mkk39
3 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
> 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
 
ThakurVinayCommented:
This all is normal. are you facing any issue, if not let it be :)

thanx
vinay
0
 
GkCommented:
There s a maximum memory use settings in SQL server. Pls set it to solve this issue.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
mkk39Author Commented:
This is really helpful
0
 
Tom KnowltonWeb developerCommented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I suggest point split for 4 first comments
0
 
ModalotEE ModeratorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now