April 8, 2011 at 6:33 am
Hi all!! and after all, sorry for my english!!!
We have a memory problem, that I don't know how to solve.
We have a Windows Server 2008 Enterprise with 8 cores and 32Gb of RAM.
We assign 20GB to SQL Server, an there is 12 GB free for OS.
Basically the problem is that Windows Server is out of memory.
For example statistics (we have to restart the server to get it normal again):
Total Memory 32GB
Used for SQL Server 20GB
Cached memory 10GB What means that, the OS use this memory???
Free Memory 512MB !!!!!!!!!
I don't know what means Cached Memory for Windows Server, but when we get out of memory the performace of the server is very bad.
I ask here becouse, I thinks there would be someone who got the same problem, but i will ask in a windows server forum too.
Thanks for all!!! and sorry for my english
April 8, 2011 at 4:14 pm
That could be your problem you can read about it in these links:
http://blogs.msdn.com/b/ntdebugging/archive/2007/11/27/too-much-cache.aspx
http://blogs.msdn.com/b/ntdebugging/archive/2009/02/06/microsoft-windows-dynamic-cache-service.aspx
Of course, this is usually only a problem when someone has used the Windows Explorer to copy files around on the server, which you shouldn't do. If this is the problem the Dynamic Cache Service should help you out.
Do you really need to leave 12 GB for the OS? (Are you running large SSIS packages or something?) I might up the memory assigned to SQL Server and only leave ~4GB to the OS.
April 10, 2011 at 6:01 am
Thanks for reply.
Yes we need 12GB becouse the server is not dedicated tio SQL, it has our two bussiness apps running.
And if I put all memory to sql server the problem will be worst I think.
There isn't other way to deal with this problem?
With "Windows Dynamic Cache Service" will I solve this issue?
April 11, 2011 at 12:26 pm
gheinze (4/10/2011)
With "Windows Dynamic Cache Service" will I solve this issue?
The "Windows Dynamic Cache Service" should solve the problem, if the problem is the memory being used by the cache.
If the problem is because of one of the applications other than SQL Server that is run on the server it probably won't.
April 11, 2011 at 12:47 pm
Thanks for reply.
If there is other app consuming memory, there is other way to figure out which app is (not using taskmanager)
Sorry for the rookie question, I'm not an Windows Server Expert.
April 11, 2011 at 1:21 pm
Are you sure memory is the problem? When the performance is bad have you checked the CPU usage and disk I/O? It is only one application that is slow, or is it all of them? (PerfMon should be able to help you track what is going on.)
April 11, 2011 at 2:39 pm
Thansk for reply so quicky!!
Yes, the performance of all apps running on the server are affected.
We have SQL Server, and an old legacy system using fox pro 2.6 and dbfs.
When we get out of memory all of our systems are slower.
People can't work until we restart the server, is that bad.
We will try the program you recomendme.
thanks so much
April 12, 2011 at 5:02 pm
My Approach will be monitoring for the queries
which are consuming high memory usage and tune them.
or switch more memory to SQL also won't help if you have bad queries running.
See at what times you have this issue and if there any other jobs are running then try to run them in a slower timings.
There lwill be lot many reasons if you have memory issue.
figure it out one by one. you can do it man,,,
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply