I would like to know how I can look into the memory usage of SQLSERVR.EXE.
It is consuming high memory of the server. I have checked the activity monitor, checked what the max set server mem was on sql (which is 2GB).
Is there another way to find out if its an individual process hogging up the memory? Checking a PID or something.
Any help will be appreciated.