Performance Best Practices

A properly tuned report begins with a properly designed query. If you find that a report or reports run slowly, start by investigating the core query. There will be cases in which you cannot tune the report query to perform any faster. In that event, use report caching or report snapshots depending on the user requirements. Another excellent technique is implementing report subscriptions to run at times when the ConfigMgr database server is underutilized.

Get System Center 2012 Configuration Manager Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.