It is also worth noting that what you are talking about may not, per se, be the "volume" being a problem, but the mic itself overloading due to high sound pressure levels. Sony's mics, in general, leave a lot to be desired.
It looks like your mic has a max SPL of 110dB, which is a good bit lower than most of the mics we use for recording music on this board. And, that's assuming the mic is properly powered by your MD to begin with.
A proper 9v power supply (i.e., a "battery box") might help, but honestly, I think you're better off going with a different mic. No matter what you do, that mic will not lend *great* or really what I would even call *passable* results for recording music (what is passable being, of course, a matter of opinion).
That mic was $75. You don't need to spend a great deal more than that to have a solution that will really work for recording music. If you can return it or sell it, I'd recommend doing so, and putting your money to work on some new mics and a new battbox.