Best Practices for SQL Reporting Services

適用於: System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3

Use the following best practices for SQL Reporting Services in Configuration Manager 2007 R2.

本主題中的資訊僅適用於 Configuration Manager 2007 R2 和 Configuration Manager 2007 R3。

  • Optimize SQL Reporting Services Queries

    Optimize your report queries. Usually, the bulk of report execution time is spent executing queries and retrieving results. If you are using SQL Server, tools such as Query Analyzer and Profiler can help you optimize queries.

  • Report Subscription Scheduling

    Whenever possible, schedule report subscription processing to run outside of normal office hours. This will reduce load on the reporting server and improve availability for ad hoc report requests.


For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email