The unity 3(.3) profiler does not help me profile my scripts memory usage since it only shows the total memory usage. Furthermore, so far the (.NET) memory profiling tools I've tried all don't work for Unity games.
For Unity Free, you could use Resources.FindObjectsOfTypeAll to see what you have loaded. It won’t find every little allocation, but at least you can track down the big ones – textures, audio clips, meshes, etc. Or try searching the Asset Store for memory profiling tools.