Making Reporting Services as a part of BI

The selection and specifications of servers and hardware infrastructure is something you need to consider in BI. Since Reporting Services is a part of BI solutions, whether or not you need a separate server and whether or not it should be scaled out or needs high availability implemented must be considered based on the size and complexity of the BI solution.

Getting ready

It's recommended to implement Distributed Architecture for BI solutions. However, it is not unusual to have all the required components related to BI in a Single Server Architecture, but the decision should be based on workloads involved with all components. Generally, the impact of all workloads related to components of BI such as data warehouse, ETL, reporting, comparatively low, in which case, Single Server Architecture will be enough for the BI solution. Since this book focuses only on Reporting Services, let's understand what sort of workloads we have to consider in Reporting...