We have a web-application that talks to a SQL Web database on another (database)server. Some queries make the memory on the web-server increase excessively till we receive an out of memory error. For instance, the RAM usage increases from 250MB tot 2300MB, and this all caused by the w3wp (yes, IIS) process.
Now my question is, what tools are there to monitor real time what is happening inside this IIS process. The stacktrace, maybe which objects are stored inside the RAM, etc
The server is running on Windows 2003 R2
Btw: I hear people thinking... google didn't help me a lot, the knowledge is here!
Thanks in advance!