That may or may not help depending on why the blocking is occurring. Here is a good primer on identifying blocked processes:
http://www.mssqltips.com/sqlservertip/2429/how-to-identify-blocking-in-sql-server-2005-and-2008/ From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Todd Hemsell Sent: Wednesday, August 07, 2013 6:54 PM To: mssms@lists.myitforum.com Subject: Re: [mssms] Slowness and blocked process when running a report WITH NO LOCK Just google it. On Wed, Aug 7, 2013 at 7:16 PM, Daniel Corkill <dan...@corkill.id.au<mailto:dan...@corkill.id.au>> 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.
