Solved

SQL Server Memory Issue

Posted on 2012-04-10
4
250 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
[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
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

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…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

730 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