Solved

SQL Server Ram Usage is very high

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

790 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