Saturday, December 08, 2012 4:42 PM
I am running a report in report server,Its a big size report and taking more than 1 hr to get report.Please help me in stopping generating report if its take more than 1 hr.is any new features in sql server 2012 ssrs for this?
Saturday, December 08, 2012 6:45 PM
Please have look at this article from msdn - > http://msdn.microsoft.com/en-us/library/ms155782(v=sql.110).aspx
Tuesday, December 11, 2012 7:24 AMModerator
If you mean the report server evaluates the execution time of a report and then determines whether to run the reprot or not, it cannot be done currently. If you want to limit the execution time of any report to one hour, you can refer to the link provided by Harsh to set the report timeout value to 3600 from the report manager.
TechNet Community Support
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Sunday, December 16, 2012 1:31 PM
Tuesday, December 11, 2012 7:43 AMI would first starting optimizing T-SQL query or stored procedure that generates report. Are you sure you have properly defined indexes? How much data does it produce?
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance