Process Explorer

Ever wondered which application is keeping what files open and what registry keys its using? Process Explorer comes very handy on that. The search functionality allows you to search for the process that open a specific file or registry key. Aside from Process Explorer, Sysinternal (Acquired by Microsoft in 2006) has produced a host of extremely useful tools. Check them out here.