Which SSRS deployment should you use?

You are the SQL administrator for your company. You have deployed two SQL Server 2008 computers named SQL1 and SQL2 on your network. You need to deploy SQL Server Reporting Services (SSRS) to support both ad hoc and scheduled reports. Yourdeployment should provide maximum performance for SSRS.
Which SSRS deployment should you use?

You are the SQL administrator for your company. You have deployed two SQL Server 2008 computers named SQL1 and SQL2 on your network. You need to deploy SQL Server Reporting Services (SSRS) to support both ad hoc and scheduled reports. Yourdeployment should provide maximum performance for SSRS.
Which SSRS deployment should you use?

A.
Deploy SSRS on one of the current SQL Server 2008 computers.

B.
Deploy a single SSRS server with a local SSRS catalog.

C.
Deploy a single SSRS server with a remote SSRS catalog.

D.
Deploy multiple SSRS servers with a remote SSRS catalog.

Explanation:

You should deploy multiple SSRS servers with a remote SSRS catalog. A scaled-out SSRS solution providesmultiple servers for reporting. By deploying separate SSRS servers, you ensure that the performance of SSRS ismaximized. In addition, the SSRS deployment will minimally affect the performance of the SQL servers. You should not deploy SSRS on one of the current SQL Server 2008 computers. This will not provide maximumperformance for SSRS. In addition, it will adversely affect the performance of the defined databases. You should not deploy a single SSRS server with a local SSRS catalog. This will not provide maximumperformance for SSRS. Using a local catalog will require some resources to be consumed by the catalog. Inaddition, a single SSRS server will not provide maximum performance for SSRS. This deployment will provide ascaled-up solution. A scaled-up solution generally provides a single server that is deployed with maximumresources, including the maximum amount of RAM and CPU resources. You should not deploy a single SSRS server with a remote SSRS catalog. Although a remote SSRS catalog willimprove the performance of the SSRS solution, deploying a single SSRS server will not provide maximumperformance for SSRS. A scaled-up solution generally provides a single server that is deployed with maximumresources, including the maximum amount of RAM and CPU resources. When deploying SSRS, you must determine whether a scaled-up or scaled-out SSRS solution is best for yourorganization. Although SSRS can be deployed on the same server as the SQL Server databases, performanceissues can occur, particularly if you have an application that performs many insert operations. To minimizeperformance issues for the SQL Server databases and for the application, you should deploy SSRS on separatecomputers from the SQL Server instances.

Objective:
Installing and Configuring SQL Server 2008

Sub-Objective:
Configure additional SQL Server components.

References:
TechNet Home > Product & Technologies > SQL Server TechCenter Home > SQL Server 2005 > Planning forScalability and Performance with Reporting Services



Leave a Reply 0

Your email address will not be published. Required fields are marked *