• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

SQL Server Memory Issue

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
jazzcatone
Asked:
jazzcatone
  • 2
2 Solutions
 
momi_sabagCommented:
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
 
Anthony PerkinsCommented:
SQL Server would only use a certain percentage of physical memory.
SQL Server will attempt to use all the memory available.
0
 
Anthony PerkinsCommented:
You can of course set the max memory SQL Server can use.
0
 
Ramesh Babu VavillaCommented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now