Solved

SQL Server Ram Usage is very high

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

A procedure for exporting installed hotfix details of remote computers using powershell
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

930 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now