Per experience, Windows Media Player is a resource hog (but Media Player Classic is pretty light!).  Winamp (with classical skins), take up the least amount of memory, while Real Player in my experience is the worst of the bunch.
Compare winamp, windows media player, real player performancewise!?