Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2010-08-17
3
Medium Priority
?
436 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 2000 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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Here is how to restore SQL Server database to the point in time.  Follow the step by step approach to restore your database at a specific point in time and also understand its alternate approach.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

585 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