Solved

SQL Server Ram Usage is very high

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Table where row act as column 11 67
MS SQL Sever Import/export problem 7 44
Changing logon server question 5 61
T-SQL Query - Group By Year 3 24
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

680 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