how the execution of sql query which is fetching the report data is aborted??
Hi All, In SSRS, if we find a report is too long to process, we cancel the report, however we find that query is still running in SQL Server profiler, therefore SQL resources are not freed at that point of time. Can anyone help me to know how the execution of sql query which is fetching the report data is aborted when we cancel the report generation?Thanks & Regards, Chaitali Thaker
May 17th, 2012 3:22am

Hi All, In SSRS, if we find a report is too long to process, we cancel the report, however we find that query is still running in SQL Server profiler, therefore SQL resources are not freed at that point of time. Can anyone help me to know how the execution of sql query which is fetching the report data is aborted when we cancel the report generation?Thanks & Regards, Chaitali Thaker
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2012 2:12am

Hi Chaitali, In SQL Server Reporting Services, a job will be created by SQL Server Agent if any of the following processes is underway: query execution on a remote or local database serverreport processingreport rendering To cancel a job that is running on the report server, we can cancel the job directly or reduce the report execution time-out value in the SQL Server Management Studio. Please refer to the steps below: Open SQL Server Management Studio, and connect to Reporting Services.Under the Report Server node, right-click on the Jobs folder and select Refresh. Then, right-click on Jobs again and click Cancel All Jobs. Right-click on the Report Server node and open the Server Properties dialog. Click the Execution option, and set the Limit report execution to the following number of seconds: to a much smaller number. After this issue is resolved, this configuration should revert to the previous state. Reference: Managing a Running ProcessSetting Time-out Values for Report and Shared Dataset Processing Hope this helps. Regards, Mike Yin
May 21st, 2012 11:26am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics