My favorite is J.H. Elliott's "Imperial Spain: 1469-1716".

To truly understand the War of the Spanish Succession requires understanding of how Spain came about, and this is my favorite book on the subject.