Solved

SQL Server Ram Usage is very high

Posted on 2014-09-16
1
210 Views
Last Modified: 2014-09-16
Hi

SQL Blooming memory usage on server, not showing what is taking up the memory even after configuring additional resource monitors.

Server is a VM, when checking the memory usage from the host it's not showing as that high but on the VM itself it is which is strange.

So I guess it is not anything to do with the VM host.

Now although every suggestion is highly appreciated and welcome but as I do not much about VMs and SQL only suggestions from members who has experience in that sort of thing are welcome otherwise it will serve to confuse me more.

Thanks very much once again
0
Comment
Question by:Mustafa Osman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
Josef Al-Chacar earned 500 total points
ID: 40325931
SQL will use as much memory as it has available. Leaving only a few hundred Meg free.

http://dba.stackexchange.com/questions/16619/how-to-control-the-excessive-use-of-ram-by-sql-server
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

737 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