?
Solved

sql taking up RAM

Posted on 2013-01-31
3
Medium Priority
?
188 Views
Last Modified: 2013-01-31
When I go into task manager I see that the process sqlservr.exe is using 15 GB of memory.  Any reason for this?  When I reboot it goes back to about 3 and then later it goes all the way up.  The CPU usage is ok but not the memory usage.  We use SQL on this server for our accounting system.  There are about 7 users.
0
Comment
Question by:mkramer777
  • 2
3 Comments
 
LVL 41

Accepted Solution

by:
Kyle Abrahams earned 2000 total points
ID: 38841173
http://www.brentozar.com/archive/2011/09/sysadmins-guide-microsoft-sql-server-memory/

Is it a problem or were you just wondering?

Note this article also gives you steps to cap it . . . but you should only do that if you really need to use it.  If everything is running fine leave it alone.
0
 

Author Comment

by:mkramer777
ID: 38841246
Oh.  I thought it was a problem.  I will just leave it alone.
0
 
LVL 41

Expert Comment

by:Kyle Abrahams
ID: 38841568
It's not as long as you don't need it for something else.  Ram is meant to be used, and speeds up the data retrieval for you.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

850 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