Solved

sql taking up RAM

Posted on 2013-01-31
3
182 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
Kyle Abrahams earned 500 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 40

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

724 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