Use the following best practices for reporting in
System Center 2012 Configuration Manager:
For best performance, install the
reporting services point on a remote site system server
Although you can install the reporting services point
on the site server or a remote site system, performance is
increased when you install the reporting services point on a remote
site system server.
Optimize SQL Server Reporting Services
queries
Typically, any reporting delays are because of the time
it takes to run queries and retrieve the results. If you are using
Microsoft SQL Server, tools such as Query Analyzer and Profiler can
help you optimize queries.
Schedule report subscription processing
to run outside standard office hours
Whenever possible, schedule report subscription
processing to run outside normal office standard hours to minimize
the CPU processing on the Configuration Manager site database
server. This practice also improves availability for unpredicted
report requests.
See Also
