The Report Profiler displays a report on all the sites and lists queried by an instance of a report, including how long individual sites and lists take to query. This can assist you when you are trying to improve the performance of a report. The information displayed in the Report Profiler report includes site level and list level data.
To run the Report Profiler:
Click Configure Reporter Settings in the Reporter ribbon to open the Reporter Settings page.
Expand the Rendering and Performance section.
Select Enable under Report Profiler, then click OK.
Click Show Report Profiler on the report.
The Report Profiler is not available when Project Cache or Work Cache is selected as a Data Source. Report Profiler is also not available when Retention Duration is enabled.
Site Level
The information displayed about the sites processed by the report includes:
Site - the site name.
URL - the site collection-relative URL to the site (this is also a link)
Time (ms) - the amount of time in milliseconds it took to query the site
The time taken to process the site will always be more than the sum of the time it took to query the lists in the site, as the total includes the time taken to process the site itself.
#Lists Matched - the number of lists queried in the site (if a site is excluded, this will be 0)
Site Filters - which web filters were run against the site and, if one excluded the site, which one it was
List Inclusion Settings: If the List of Lists is enabled in the report, BrightWork.Reporter.Providers.ListsFromListCollectionProvider will be displayed.
The List of Lists is enabled by default in many of the Template Reports.
List Level
If a site contains lists that were processed by the report, they will be displayed in a collapsible section underneath the report. The information displayed about these lists includes: