Ed Wagner (3/3/2014)
If you aren't familiar with Process Explorer, I would highly recommend it. For your specific need, they have a "Find" icon you can drag onto a specific window and it'll tell you all about it. There's a level of detail there that you won't find in many other tools.
They also have the reverse. For processes with windows (like SSMS) you can right-click on the offending process's line in Process Explorer, go to the "Window>" sub-menu and select "Bring to Front" to see which SSMS instance is the one taking so much memory.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]