I'm going to upgrade to a dedicated server soon. The problem is that they said my site was using over 600 connections and 40% of the CPU that my site was on!! They mentioned that there could've been SQL queries that were being opened but not closed.
Unfortunately I cannot show you the site right now because it's been taken offline. Hopefully it'll be back up tomorrow.
It's normally at
http://board.midibuddy.net
What can be causing such a heavy server load?