Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 628
  • Last Modified:

Low SQL 2008 memory usage

Hi guys, I have a Windows 2008 Ent edition 64bit and SQL 2008 Ent 64 bit. Recently the performance is very sluggish. It has got 12gb of physical ram. I looked at the task manager. Memory usage is 97%. However when i look at the sqlservr.exe process, its only using 116,792K of ram. Why is the ram consume so little? This is the production server with high specs. I have a similar testing environment running on VM and it shows the correct amount of ram for sqlservr.exe process. Please advise.
0
totallypatrick
Asked:
totallypatrick
3 Solutions
 
skaraiCommented:
SQLserver.exe itself has a small memory foot print as you can see the rest of the memory used should be occupied by primarily data cache (data pages read from the database files and allocated in memory to spedd up the process since memory is factor 1000 faster than disk i/o. In Perfomance monitor add the SQL memory counters and you should  'see' the occupied memory and how it is used. Vmware offers the benefit of an additional abstraction layer which simplifies seeing where your memory is used. You can open a perfmon session in the machine in vmware as well and use the SQL memory counters they should mimick your physical machine.
0
 
tigin44Commented:
SQL server memory manager principals explained in this article

http://blogs.msdn.com/b/slavao/archive/2005/02/11/371063.aspx

SQL server memory management also explained in this link

http://www.sqlservercentral.com/articles/Memory/74867/

hope this links helps you...
0
 
lcohanDatabase AnalystCommented:
And you could easily find what/how is being used - please see solution at:

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_27345109.html
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
totallypatrickAuthor Commented:
But i have set the Max memory in SQL manager that leaves 2GB for OS but i'm still seeing physical memory used is 96 to 97%
0
 
skaraiCommented:
There are other processes runnign that will occupy physical memory in the low 2 GB adress space. SQL may have nothing to do with it. On the other DTSrun can occupy memory in the lower 2 GB range. Start Task manager - under processes make sure you check the box to allow to see precesses from all users then under view select columns add the memory commit size to the visible counters (you may have to expand your window to the right to see the newly added counter) this will further help you in tracking down what process is occupying your memory.
0
 
lcohanDatabase AnalystCommented:
SQL data(mainly) and code cache will take most of the physical RAM from that box unless you specify that in SQL MEM config: http://support.microsoft.com/kb/321363

"[...]  the Task Manager and Performance Monitor may show that the physical memory available on the computer is steadily decreasing until the available memory is between 4 to 10 MB."
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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