Why is my site intermittently unavailable?

It depends on the reason. If your site has some issues with plugins, you can possibly be causing your site to go over resources which will cause it to go offline for a short time. I'd start by asking dreamhost about it