Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Implementing Scale-Out deployment of SQL Server Reporting Services


There are various deployment modes available with SQL Server Reporting Services; the recipe Preparing and Installing Reporting Services highlights the new deployment mode that is available in SQL Server 2008 R2. Similar to the core database engine and analysis services, the reporting services can also be deployed as a scale-out model by configuring the multiple report servers to use a share report server database.

To provide further high availability to the reporting services platform, you might decide to host the report server database on SQL Server failover cluster nodes. The advantage of this scale-out deployment is a highly available and scalable reporting services platform. In this deployment mode, each report server is referred to as a node. Nodes participate in the scale-out, if the report server is configured to use the same remote report server database. The load balancing of reports is managed by the load balancer...