I think the most common set up is to have your application server and DB on different hosts. That way you can scale each independently.