I've ran into a big memory issue that is causing major trouble on the server.
On the machine there is Windows 2003 x86, SQL Server 2005 and an IIS on which many applications are running. 8 processor system with 4Gb of RAM. The main problem that appeared recently is that the memory usage is always high, about 3.8Gb. After some time after reboot it starts to grow to 3.8 - 4Gb, and then some apps stops responding to the requests, sql server query execution is slowing and the only thing that is left to be done is reboot, which is bad.
When I look into the task manager on processes, the sum of consumed memory is hardly greater than 1Gb. When i opened the vmmap monitor, it shows me the same thing.
SQL Server maximum memory is 2Gb. Page file is 2 - 4Gb.
What ideas do you have about how can I figure out what consumes so much memory?