Possibly Dumb Question

  • Why would you want to add SSAS or SSRS as a feature of a database engine instance as opposed to creating a new instance on the same box. What's the use cases?

  • SSAS /SSRS and SSIS are merely free tools that Microsoft kindly gives us when we purchase their SQL Server software. You install the SQL Server engine - then you can install other features such as SSRS and SSAS which connect to the databases which the SQL Server engine is responsible for.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • _nzrdb6 (9/11/2013)


    Why would you want to add SSAS or SSRS as a feature of a database engine instance as opposed to creating a new instance on the same box. What's the use cases?

    As Abu alludes to, SSRS and SSAS aren't features of the database engine but are separate applications that are included in a SQL Server license. Whether you install them as part of the default installation or as separate instances you still have the same constraints, the CPU power, IO, and memory usage that all require. In reality including them in the license is a great marketing tool for MS because in any kind of large or busy installation you really need to have the 3 products on 3 servers to get the best performance out of each, and that requires 3 SQL Server licenses, not 1.

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

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