Tham khảo tài liệu 'sams microsoft sql server 2008- p3', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | High-Availability Deployment Considerations 81 Report Servers to a web farm . Host the Report Server catalog in a SQL Server instance on a separate box from your data sources transactional data warehouse or line-of-business database or at least make sure that a SQL Server instance can handle additional workload. For scale-up scenarios SSRS 2008 supports a 64-bit platform for both x64 Opteron Athlon64 and Xeon EMT64T CPUs and IA64 Itanium CPU . A 64-bit platform overcomes the 4GB memory limitation of the 32-bit platform and should be considered for reporting applications with high memory demand. A reporting application that renders a fair amount of or large Microsoft Excel or PDF reports is an example of a high-memory-demand application. For reliability use redundant components at least two SSRS web servers and a database cluster for the Reporting Services catalog database redundant disk arrays and network pathways. Although high availability requires at least two servers three is better. With three servers you can do maintenance on one of the servers and still have a high-availability configuration running in your environment. For cost evaluation when deciding whether to buy more servers with a smaller number of CPUs versus fewer servers with a larger number of CPUs in each consider the price of the hardware the additional costs associated with extra servers and the cost of a reporting-solution failure. As the number of servers grows so do the server management overhead and other costs such as the cost of additional space cooling and energy. 5 High-Availability Deployment Considerations To create a highly available Reporting Services installation an administrator can deploy Reporting Services on a web farm and use clustering for the Reporting Services catalog database. Enterprise Edition of Reporting Services is the only edition that supports web farm deployment in the production environment. Developer Edition and Evaluation Edition can be deployed on a web farm .
