You design a Business Intelligence (BI) solution by using SQL Server 2008. You have deployed a SQL Server 2008 Reporting Services (SSRS) application. The number of users for the SSRS application increases. This results in performance problems. The datasets for the reports are optimized. You investigate the SSRS deployment and discover the following characteristics:

Users report that the reports take a long time to run.

There are a large number of graphical reports that summarize data.

Subscription processing affects the performance of reports that are

run by interactive users. You need to modify the SSRS infrastructure to resolve the performance problems. Which scale-out strategy should you use?

Question

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have deployed a SQL Server 2008 Reporting Services (SSRS) application. The number of users for the SSRS application increases. This results in performance problems. The datasets for the reports are optimized. You investigate the SSRS deployment and discover the following characteristics:

Users report that the reports take a long time to run.
There are a large number of graphical reports that summarize data.
Subscription processing affects the performance of reports that are

run by interactive users. You need to modify the SSRS infrastructure to resolve the performance problems. Which scale-out strategy should you use?

Accepted Answer

B. Multiple SSRS servers and a single reporting database server

Answer

A. Single SSRS server and a single reporting database server

Answer

C. Single SSRS server and multiple reporting database servers

Answer

D. Multiple SSRS servers and multiple reporting database servers

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have deployed a SQL Server 2008 Reporting Services (SSRS) application. The number of users for the SSRS application…

Question

Options

How the community answered

Community Discussion