Reporting Service部署—架构、性能优化以及最佳实践

– 推荐2节点的服务器部署；
测试报告和数据
• 测试环境：全部基于SQL Server 2008
RS2008扩展架构（远程目录服务器和远程数据源）
Jul 09 2008, 04:24 PM by CarlRabeler
服务器配置
• Reporting Services “Front-End” s ：
Reporting Services Scale-Out Architecture
目录服务器：Catalog Server
• 目录服务器包含2个数据库:
– ReportServer (RSDB) ：
• • • • • data source information for the report； the default parameter values,； and the report itself； History and execution snapshots are stored in here. Note that for ad-hoc reports, this data is not loaded from the RSDB catalog database because the report comes from the RDL that is executed, published, and bound to the user’s session
– MemoryLimit：
• In SQL Server 2008. Its default is 60% of physical memory. Increasing the value helps Reporting Services handle more requests. After this threshold is hit, no new requests are accepted.
Reporting Service部署 ——架构、性能优化以及最佳实践
Agenda
• • • • 基于性能的考虑 测试报告和数据 扩展部署架构 性能优化最佳实践
基于性能的考虑
• RS2008本身的响应效率：
– 3~4倍于RS2005的并发用户；
• 扩展建议：
– 推荐最新的4*4核处理器；
• 性能表现优异，高吞吐量（响应时间和响应条件） • 其他硬件环境相同的情况下提升3~5倍的响应效率；
优化报表服务
• 扩充AS
– ReportServerTempDB (RSTempDB)：
• all user session information and live or cached execution snapshots are stored in here
优化目录服务器性能
• 最佳实践建议：
– 使用专用服务器
• Same server as SSRS Windows/Web Services • Same server as your data source relational database (SQL)；
测试报告—Errors/Sec
测试报告—平均响应时间
测试报告—平均响应数量
分项测试报告—PDF
分项测试报告—ELX
分项测试报告—Html
其他测试报告
扩展部署架构
Reporting Services Scale-Out Architecture
目录服务器：Catalog Server
– Hardware Configuration #1 (2x2): One HP Proliant BL 460c G1 computer with two x64 dual core processors and 16 GB RAM – Hardware Configuration #2 (4x2): One Dell 2970 computer with four x64 dual core processors and 16 GB RAM – Hardware Configuration #3 (4x4): One HP Proliant BL 460c G5 computer with four x64 quad core processors and 16 GB RAM
• Reporting Data Source Server
– one HP Proliant BL 460c G5 computer with four x64 quad core processors and 16 GB RAM for all tests. The Report Server data source server was connected to an EMC Clarion CX3 Model 40 SAN
优化报表服务
• 处理大工作量：
– 掌控大型报表：汇总粒度、报表尺寸； – 缓存； – 配置和计划：超时、快照； – 预先存储其他报表格式； – 缓存数据驱动订阅的参数化报表； – 增加快照数量； – 调整Web服务
优化报表服务
• 监控和分析：
– 视图：ExecutionLog2
优化报表服务
• 内存配置：
• RS2008：
– 非内存限制的：
• RSReportServer.config：Memory Configurations for SQL Server 2008 Reporting Services ；
Note：Keep in mind that certain data providers are not available for 64-bit (for example, the Microsoft JET provider or certain third-party providers). In these cases, customers will need to continue using 32-bit for their Reporting Services environment
– MaximumMemoryLimit：
• in SQL Server 2008. Its default is 80% of physical memory. But unlike the SQL Server 2008 version, when its threshold is met, it starts aborting processes instead of rejecting new requests.
That is not best way!
优化目录服务器性能
• 最佳实践建议：
– 高性能硬盘
• To optimize your disk I/O； • Have more smaller sized disks with faster rotation speeds (e.g. >= 15,000 RPMs) rather than fewer larger sized disks with slower rotation speeds； • Maximize and balance your I/O across all of the available spindles. • Use separate disks for RSDB and RSTempDB • Pre-grow your SSRS report server catalog databases instead of having SQL Server perform autogrow on these databases. • For your SSRS server catalog databases, stripe your database files to the number of server cores at a ratio of 0.25 to 1.0 depending on how heavy your workload is. • RAID
• Reporting Server Catalog Servers
– HP Proliant BL 460c G1 computer with two x64 dual core processors and 8 GB RAM for all tests. The Report Server catalog server was connected to an EMC Clarion CX3 Model 40 SAN
优化目录服务器性能
• 最佳实践建议：
– 64位服务器 – Backup/Restore – Maintain Your SSRS Report Server Catalog Databases
优化报表服务
• 64位：
– 内存密集型应用（ memory-intensive ）； – 针对大型报表的处理效率； – 并发访问用户数量；