Hi,
When running the report 'Status of a specified package and program deployment',
the report displays the various statuses, but when drilling in by selecting a
status and accessing the report 'All system resources for a specified package
and program deployment in a specified state' it is taking 4-5 mins to load the
report.
I'm using a tool by Quest called Spotlight and I'm noticing during this 4-5
mins a blocked process appears. When I check the spid in SQL Activity monitor
it's the Report Server and the ReportServer db. Once the report finally appears
refreshing it is quick and I haven't noticed this slowness with any other
report.
Since I'm not an SQL guy I was hoping someone had suggestions for how I can
diagnose this further. CM12 SP1 CU1 w/ SQL 2012 SP1 no CU.
Daniel.
