The Microsoft System Center Configuration Manager 2012 reporting feature provides a set of tools and resources that help you use the advanced reporting capabilities of SQL Server Reporting Services. The following considerations should be taken into account when before you configure reporting in Configuration Manager 2012.
Prerequisites for Reporting
There are a number of dependencies and configurations that must be considered before you can manage reports in Configuration Manager.
Dependencies External to Configuration Manager 2012
The following table describes the external dependencies for SQL Reporting Services running in Configuration Manager 2012.
| Dependency | More Information |
|---|---|
|
SQL Server 2008 Service Pack 1 (SP1) Reporting Services |
Before you can use reporting in Configuration Manager 2012, you must install and configure the SQL Reporting Services feature in SQL Server 2008 SP1. For more information about installing and configuring SQL Server Reporting Services, visit the SQL Server Reporting Services Web site at . |
Dependencies Internal to Configuration Manager 2012
The following table describes the dependencies for reporting that are internal to Configuration Manager 2012.
| Dependency | More Information |
|---|---|
|
Reporting Services point site system role. |
The Reporting Services point site system role must be configured before you can use the reporting feature in Configuration Manager 2012. |
Best Practices for Reporting
Use the following best practices for SQL Reporting Services in Configuration Manager 2012:
- Location of SQL Reporting Services
Installation
Configuration Manager 2012 supports locating the SQL reporting server on the site server or a remote site system server. However, for performance reasons, you should locate the SQL reporting server and the reporting services point on a remote site system server.
- Optimize SQL Reporting Services Queries
Optimize your report queries. Usually, the bulk of report run time is spent running 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 Configuration Manager 2012 site database server and improve availability for ad hoc report requests.