Solved

SQL Server Ram Usage is very high

Posted on 2014-09-16
1
213 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

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

691 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