Monday, August 15, 2011

High availability and Scale Out Microsoft Reporting Services

For Reporting Services HA - load balance multiple report servers and then share a single report server database. The database can be installed on a remote SQL Server instance or locally with one of the report servers.The SQL Server instance that hosts the report server database can be part of a failover cluster.
After you configure a report server scale-out deployment,
the report server nodes can be load balanced in a Network Load Balanced (NLB) cluster to support high-volume reporting.
You can use a software or hardware solution to implement the NLB cluster. Deploying Reporting Services in an NLB cluster is only necessary to increase the responsiveness of the report server or to increase the number of interactive reports that can be processed concurrently.
 Scheduled reports and subscription processing are faster on a scale-out deployment, but do not require an NLB cluster to get faster performance.
To create and configure the NLB cluster, you must use software and tools that support that functionality.
There are load balancing features in Microsoft Windows Server operating systems and in third-party applications.
By itself, Reporting Services does not provide load balancing features or the ability to define a single virtual server URL
to access multiple report server nodes. The hardware or software solution you select must provide a way to define a virtual server name
 that provides a single point of entry to all the nodes in a report server scale-out.
Note: Standard Edition of SQL Server doesn’t support Reporting

No comments:

Post a Comment