Best Practices for SQL Reporting Services

Aplica-se a: 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.

noteNota
As informações neste tema aplicam-se apenas ao Configuration Manager 2007 R2 e ao 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.

Consulte Também

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

Conteúdo da Comunidade

Mostrar: