I've always tried to separate transactional databases from those supporting analytical queries if there's going to be any question that there might be contentio

I've always tried to separate transactional databases from those supporting analytical queries if there's going to be any question that there might be contention. The latter often don't need to be real-time or even near-time.