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.
For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.