Solved

sql taking up RAM

Posted on 2013-01-31
3
178 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 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now