Dungeons & Dragons Music
The music you want for D&D will typically be medieval music, chants and movie soundtracks. Here are my playlists:

Tavern-
  • Ancient Airs, Cantigas & Dances
  • The Art of the Bawdy Song
  • A Bawdy Elizabethan Evening in Merrie Olde England
Temples/Churches-
  • Chant I-IV
Normal-
  • Army of Darkness
  • Conan the Barbarian
  • The Dark Crystal
  • First Knight
  • The Lord of the Rings: The Fellowship of the Ring
  • The Lord of the Rings: The Two Towers
  • The Lord of the Rings: The Return of the King
  • Henry V
  • Warriors of the Silver Screen (2 discs)
  • Willow

The Art of the Bawdy song includes instrumentals (mandolyns, flutes, etc.) and mostly male vocals. It's basically a bunch of drinking songs. If you listen carefully to the words, you'll find it quite raunchy. It's perfect for your typical tavern scene. I always start with this song before the play begins. I find that it transports the players into the D&D world quite well. I even listen to it while decorating to keep me in the mood.

The Chant series of CDs (and similar titles) are great for the average temple or church as well as abandoned temples that you may be exploring. They convey a feeling of reverence and quiet reflection that the characters would probably be feeling at the time. Sometimes I can almost see the sunlight filtering through the stained glass windows when I listen to these discs.

Perhaps a better name for "normal" would be "misc." It's the normal adventuring music that doesn't fit into the other two categories. Eventually I would like to seperate it into categories like "dungeon crawl", "sneaking around", "riding", "battle", "victory". I haven't done this yet because it requires a great of effort, listening to every track and attempting to classify it (possibly into more than one category).
Warriors of the Silver Screen duplicates some music from the other soundtracks but I don't pull them out. They are some of the best songs anyway so they end up playing a little more often than the others.
I didn't buy the soundtrack to The Dark Crystal. The special edition DVD has an option to play music only so I ripped the music and separated it into several MP3 files.
The Lord of the Rings series is excellent and it conjures up images from the books/movies while you adventure. I had to remove this from my rotation because some group members object to the music.

There are more CDs that I haven't acquired yet. These include: "Courts, Kings, and Troubadours", "Medieval Songs and Dances", "Sinners & Saints" and "Excalibur". These plus the ones that I already have will give me about three hours of tavern music, five hours of temple music and thirteen hours of normal music. This means that we can go several sessions without hearing the same track twice.