Memory Problems Windows server 2008/sql server 2008
Posted on 2010-09-22
We have the ssas cube server was setup; the server has been very sluggish. Under the Task Manager for the server the physical memory has been at about 99% for most of the time. On a few occasions it got so slow that we resorted to restarting the machine. This seemed to get things faster but when I opened up the task manager again, I noticed that the RAM taken up started at about 4GBs and steadily climbed back up to the 32GBs that are in the machine. When I looked at the processes it seems that sqlservr.exe is taking up about 22GBs, and when I matched up the PID with the instance I noticed it was the process that was servicing the localserver instance of SQL server.
I restarted the sqlservr.exe process and the physical memory went from 99% to about 36%, it stayed there for some time but eventually started climbing up again, and currently it is at 88%.
The above problem I am not able to detect and any reccomendations highly appreciated.