Topic Last Updated—August 2008
Use the following best practices for SQL Reporting Services in Configuration Manager 2007 R2.
 Note |
|---|
| 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.