Submit a ticketCall us

Cloud Workloads: Meet Your New Hybrid IT Reality
Have you found yourself in that evolving, hybrid IT grey area and wondering if cloud workloads are now part of your purview? And if so, will monitoring cloud workloads require a new set of dedicated cloud monitoring tools? Your answers: yes, they should be, and no, they don’t.

Find out how SolarWinds® Server & Application Monitor (SAM) can help you monitor your cloud workloads side by side with your on-premises workloads. Register Now.

Home > Success Center > Troubleshooting Tools > SQL Server is showing full memory usage

SQL Server is showing full memory usage

Table of contents
Created by Gary O'Donovan, last modified by MindTouch on Jun 23, 2016

Views: 1,017 Votes: 1 Revisions: 6

Overview

The SQL Server is consuming 95% of the server's RAM.

Environment

All SQL Server versions

Detail

 

SQL Server will consume as much memory as you will allow it. By default, that number would encompass 100% of your numerical memory on your machine. 

 

SQL Server will dynamically use memory so even if you set max memory to 12 GB, if SQL requires then it will use memory to a max of 12 GB.

 

The reason for this is that SQL Server cache the data in the database in RAM so that it can access the data faster than it could if it needed to read the data from the disk every time a user needed it.

 

Normally 4 Gigs is allocated to the Operating system (that  depends on the amount of software running on the server)

 

You can specify a Limit in SQL Server Management Studio.

In Left pane tree, right-click on  Server  instance > Go to Properties > Memory.

Here you can specify a Max and Min Limit.

 

 

 

Last modified

Tags

Classifications

Public