is keeping your OLAP and OLTP databases on the same server is considered bad practice

  • Hi,

    We have been asked to host OLAP and OLTP databases on the same server. Is this bad practice.

    I believe OLTP db's would be managed under database engine and OLAP under anaylsis services. Should the run on the same server or instance?

    regards

  • I'm not sure what you mean by the term OLAP. Are you talking about cubes or data warehouse/data mart databases?

    In either case, best practice is to keep them separate. The server configurations used to get the best performance out of your databases are different based on load (OLTP vs reporting). Also Analysis Services and the Database engine will be competing for resources if you put them on the same server, so neither will perform as well as if you have them separate.

    Having said that, if you are a small shop with small databases/cubes, you can probably get away with running on the same server. From a cost perspective that's the best way to do it, until the business can't live with the performance issues.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply