Help!... Memory Use on Windows 2008 R2, SQL Server 2005 x64. The physical is 98%

Question

Help!... Memory Use on Windows 2008 R2, SQL Server 2005 x64. The physical is 98%

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 1

Sorry, I see no evidence of 98% memory use. SQL is using 1.94GB and is the largest consumer of the 2.83GB being used by all processes collectively.

From your original post:

The problem is... that the use of the Physical Memory for the server has come to 97% or 98%...

Which measurement or tool is telling you this? If it's a person telling you this, I would challenge them for proof.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

SS999 SSCommitted Points: 1663 More actions · Answer 2

Any netbackup going on behind the scene? U can check on your system tray.

juanc.aguirre Say Hey Kid Points: 677 More actions · Answer 3

opc.three (3/15/2012)
Sorry, I see no evidence of 98% memory use. SQL is using 1.94GB and is the largest consumer of the 2.83GB being used by all processes collectively.
From your original post:
The problem is... that the use of the Physical Memory for the server has come to 97% or 98%...
Which measurement or tool is telling you this? If it's a person telling you this, I would challenge them for proof.

Hello!!....

Noup... I'm seeing this information in the Windows Task Management... and in the Resource Monitor too.

This is making me cracy!!

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 4

Post a screenshot.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

juanc.aguirre Say Hey Kid Points: 677 More actions · Answer 5

juanc.aguirre

Say Hey Kid

Points: 677

March 15, 2012 at 3:54 pm

#1460234

opc.three (3/15/2012)
Post a screenshot.

Sure...

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 6

What did I wander into with this thread? 😛

My best guess is you have something running that has a memory leak. Can you restart the server after disabling each of the major services, one at a time? For example go into Services MMC, disable IIS services, restart the server and wait to see what happens to memory. If it scales up to 98% repeat for SQL Server Agent service and restart, then if memory scales up again do the same for the main SQL Server service, etc. etc.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

juanc.aguirre Say Hey Kid Points: 677 More actions · Answer 7

opc.three (3/15/2012)
What did I wander into with this thread? 😛
My best guess is you have something running that has a memory leak. Can you restart the server after disabling each of the major services, one at a time? For example go into Services MMC, disable IIS services, restart the server and wait to see what happens to memory. If it scales up to 98% repeat for SQL Server Agent service and restart, then if memory scales up again do the same for the main SQL Server service, etc. etc.

Well... then this like to be not a problem with the SQL Server... Like to be a SO problem...

This type of test have to be made by the Server Administrators, I'll call for them so that perform the tests.

Thanks a lot... I'll post the results.

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 8

Chances are you have 'lock pages in memory' enabled which prevents memory SQL Server allocates to the buffer pool from showing in Task Manager. Same symptoms: http://www.sqlservercentral.com/Forums/FindPost1356979.aspx

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

juanc.aguirre Say Hey Kid Points: 677 More actions · Answer 9

Hi everyone, I forgot reply the final solution to this problem... sorry...

The reason of all this mistery, was a bad configuration on the hypervisor, in this case VMware. The machine is in a virtual enviroment, an the allocation of memory was wrong!!!... the Reserved Memory was 8 GB... ok!... BUT... the Limit was 4 GB !!!!... so... the OS apparently had 8 GB, but was limited on 4 GB.

Thanks to everyone for the help... !! (and sorry for my english!!!)