Solved

SQL Server Memory Issue

Posted on 2012-04-10
4
249 Views
Last Modified: 2012-04-16
We have an enterprise version of SQL Server2008 . We have been seeing some memory usage issues lately. I was of the understanding that regardless of the amount of memory on a box  (say its 10GB) that SQL Server would only use a certain percentage of physical memory. (Like up to 80% or in this case 8 GB)  Perhaps this was with older versions of SQL Server, I'm not sure.  I have done some reading and its rather confusing. Any clairification provided would be greatly appreciated.

Jason
0
Comment
Question by:jazzcatone
  • 2
4 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 37830407
SQL Server will not use all the memory on the machine, since the operating system also needs memory and SQL Server is integrated with windows in a way that takes that OS memory consumption into consideration
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37830590
SQL Server would only use a certain percentage of physical memory.
SQL Server will attempt to use all the memory available.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 250 total points
ID: 37830595
You can of course set the max memory SQL Server can use.
0
 
LVL 10

Assisted Solution

by:sqlservr
sqlservr earned 250 total points
ID: 37831286
which version of SQL Server do you use, if you are using SQL Server 64 bit, then it os the default habit of SQL Server to consume the memory, in SQL Server 64 bit machine, total memory is consumed by the buffer pool itself.to know more information use
DBCC MEMORYSTATUS, command to check which part of it is consumed,

if  you still feel that SQL Server is still consuing the memory, add a perfom counter for Available MBytes, its values should not be less than the 10% of installed RAM,that means if your Server has 6 GB of installed RAM, then Available Free bytes should not be less than 600 MB.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Suggested Solutions

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…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

809 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