?
Solved

sql taking up RAM

Posted on 2013-01-31
3
Medium Priority
?
184 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 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 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

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 …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

765 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