Solved

Report running longer in SSRS than Oracle

Posted on 2011-09-14
4
613 Views
Last Modified: 2012-08-13
I have several long running reports that have been developed in SQL Server 2008 and Oracle.  When I run these reports via SSRS the reports are taking much longer than if I run them in BIDS or SQL Server.  to the point that sometimes the report will timeout and fail on SSRS.  Is there general explanation as to why a report would take so much longer ( sometimes double the time) in SSRS then it is in Oracle or SQL Server without getting into the code for each report.

0
Comment
Question by:Rhonda Carroll
4 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 250 total points
ID: 36542782
sometimes the longer runtimes are common, with the report via SSRS rather than run locally. Take a look at the sessiontimeout and sessionaccesstimeout:
http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/131479a2-814d-4fe0-87cf-25b64eb44998/
http://blogs.msdn.com/b/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
0
 
LVL 25

Expert Comment

by:TempDBA
ID: 36553650
Are you seeing significant difference here? When you are running query at the back end, is it performing well?
0
 
LVL 27

Expert Comment

by:planocz
ID: 36557688
Most of the time I have seen that the SQL Statement is not correct based on the parameters.
0
 
LVL 17

Assisted Solution

by:k_murli_krishna
k_murli_krishna earned 250 total points
ID: 36561879
When reports are run in BIDS or SQL Server or Oracle it is a physical execution where it is essentially a client SQL execution i.e. syntax check i.e. spelling & grammar followed by semantics check i.e. presence of tables and columns as well as privileges and then actual execution of optimized query using best plan by optimize takes place.

In SSRS, all this will happen but there will be additional processing as part of reporting service. This is all the more highlighted for low to medium time taking queries. A particular report may be selected to be shown which needs additional time for execution.

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

733 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