One of my users was having problems connecting to one of the instances on our consolidated server. This server holds several instances of both 2005 and 2008. I found out that the memory was being used by one instance alone. Is there a dmv that could have told me this and also what is the best way to monitor which instance/s is using most of the memory.