效能、快照、快取 (Reporting Services)Performance, Snapshots, Caching (Reporting Services)

報表伺服器的效能會受到一些因素組合的影響,包括硬體、存取報表的並行使用者數目、報表中的資料量,以及輸出格式。Report server performance is affected by a combination of factors that include hardware, number of concurrent users accessing reports, the amount of data in a report, and output format. 若要了解安裝特有的效能因素以及哪些補救措施可產生所需的結果,您必須取得基準資料並執行測試。To understand the performance factors that are specific to your installation and which remedies will produce the results you want, you will need to get baseline data and run tests. 如需有關工具和指導方針的詳細資訊,請參閱下列 MSDN 出版品:< Reporting Services 效能最佳化 >和< 在 SQL Server 2005 Reporting Services 報表伺服器上使用 Visual Studio 2005 執行負載測試>。For more information about tools and guidelines, see the following publications on MSDN: Reporting Services Performance Optimization and Using Visual Studio 2005 to Perform Load Testing on a SQL Server 2005 Reporting Services Report Server.

要考慮的一般原則包括下列各項:General principles to consider include the following:

  • 報表處理和轉譯是需要大量記憶體的作業。Report processing and rendering are memory intensive operations. 可能的話,請選擇具有大量記憶的電腦。When possible, choose a computer that has a lot of memory.

  • 在個別的電腦上主控報表伺服器與報表伺服器資料庫會比在單一高階電腦上主控這兩個項目提供較佳的效能。Hosting the report server and the report server database on separate computers tends to provide better performance than hosting both on a single high-end computer.

  • 如果所有報表的處理速度都很慢,請考慮採用向外延展部署,以便讓多個報表伺服器執行個體支援單一報表伺服器資料庫。If all reports are processing slowly, consider a scale-out deployment where multiple report server instances support a single report server database. 為了獲得最佳結果,請使用負載平衡軟體,將要求平均分散到部署中。For best results, use load balancing software to distribute requests evenly across the deployment.

  • 如果單一報表的處理速度很慢,而且該報表必須視需要執行,請調整報表資料集查詢。If a single report is processing slowly, tune report dataset queries if the report must run on demand. 您也可以考慮使用您可以快取的共用資料集、快取報表,或將報表當做快照集執行。You might also consider using shared datasets that you can cache, caching the report, or running the report as a snapshot.

  • 如果採用特定格式之所有報表的處理速度很慢 (例如,轉譯成 PDF 時),請考慮採用檔案共用傳遞、加入更多記憶體,或選擇不同的格式。If all reports process slowly in a specific format (for example, while rendering to PDF), consider file share delivery, adding more memory, or choosing a different format.

  • 若要了解處理某份報表和其他使用標準需要多久,請檢閱報表伺服器執行記錄。To find out how long it takes to process a report and other usage metrics, review the report server execution log. 如需詳細資訊,請參閱 報表伺服器 ExecutionLog 和 ExecutionLog3 檢視For more information, see Report Server ExecutionLog and the ExecutionLog3 View.

  • 如需有關如何透過微調記憶體管理組態設定來減少效能問題的詳細資訊,請參閱 設定報表伺服器應用程式的可用記憶體For more information about how to mitigate performance issues by tuning memory management configuration settings, see Configure Available Memory for Report Server Applications.

本節內容In This Section

監視報表伺服器效能Monitoring Report Server Performance
描述您可以用來追蹤伺服器之處理負載的效能物件。Describes the performance objects you can use to track the processing load on your server.

設定報表處理屬性Set Report Processing Properties
描述將報表設定為視需要執行、從快取執行或依據排程當成報表快照集執行的方式。Describes ways of configuring a report to run on demand, from cache, or on a schedule as a report snapshot.

設定報表伺服器應用程式的可用記憶體Configure Available Memory for Report Server Applications
描述如何覆寫預設記憶體管理行為。Describes how you can override default memory management behavior.

快取多個報表 (SSRS)Caching Reports (SSRS)
描述報表伺服器上的報表快取行為。Describes report caching behavior on a report server.

快取共用資料集 (SSRS)Cache Shared Datasets (SSRS)
描述報表伺服器上的共用資料集快取行為。Describes shared dataset caching behavior on a report server.

處理大型報表Process Large Reports
提供如何設定和散發大型報表的建議。Provides recommendations on how to configure and distribute a large report.

設定報表和共用資料集處理的逾時值 (SSRS)Setting Time-out Values for Report and Shared Dataset Processing (SSRS)
說明如何設定查詢和報表處理的逾時。Explains how to set time outs on query and report processing.

另請參閱See Also

管理執行中的處理序 Manage a Running Process
驗證報表執行Verifying a Report Run