Solved

SSRS Report user closes the browser, the report stored procedure still running.

Posted on 2010-08-17
3
426 Views
Last Modified: 2012-05-10
We have a situation where the user runs a report, closes the browser and runs it again. User runs it and closes it multiple times causing false load on the SQL server and the cpu spikes to 100%.

Is there a way to stop executing the report SQL Procedures/statements in SQL Server when the report browser is closed.
0
Comment
Question by:dba2dba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 7

Expert Comment

by:lundnak
ID: 33457702
Is this a long running report?
I had a similar instance, but in my case the report was buggy and would run forever.  So I set the report time in in SSRS to be five minutes.  This was an adequate amount of time because none of the reports on the server would run that long.
0
 
LVL 8

Author Comment

by:dba2dba
ID: 33457987
It is a long running but, I could not set time out to a value as there are lot more long running ones.

I wanted to know what happens when the SSRS User closes the report Browser while the report is being fetched.

Does it continue to run in the back ground or does it stop exeuting?

Thanks,
0
 
LVL 7

Accepted Solution

by:
lundnak earned 500 total points
ID: 33458430
The SQL Server session continues to run.  I haven't found a method yet to have SSRS close the orphaned sessions.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question