Best Practices for SQL Reporting Services

Applies To: 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.

The information in this topic applies only to Configuration Manager 2007 R2 and 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.

See Also

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