Solved

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

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

867 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now