WITH NO LOCK Just google it.
On Wed, Aug 7, 2013 at 7:16 PM, Daniel Corkill <[email protected]> wrote: > 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. > >
