Use QA as mentioned in this post, it will tell you what's running inside SQL.

To set a cap on memory you should probably go through Enterprise Manager, into properties, memory and set the max value.