Solved

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

Posted on 2010-08-17
3
421 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
  • 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS SQL with ODBC 5 36
SSRS 2013 - Overlapping reports 2 21
SQL Server 2012 r2 - Sum totals 2 24
SQL Server 2012 - Merge Replication Issue 1 20
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
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 insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

776 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