Blocking while running reports

Question

Blocking while running reports

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

klnsuddu SSCertifiable Points: 5836 More actions · Answer 1

Have you looked at the TSQL to optimize the code? The problem you are encountering seems to be a problem in a poorly written query. You need to check the query that the report is running.

It's NOT t-sql. The datasource is ORACLE database & all the reports use ORACLE pakages to get the data from ORALCE database. So I need to check PL-SQL code that the report is using right?

thanks

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Yes - check your SQL that is running. Check your Oracle tables and check your Oracle indexes.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

klnsuddu SSCertifiable Points: 5836 More actions · Answer 3

Is the below SSRS configuration correct? please advice me

SQL Server 2005 Reporting Services is installed on Server A and it's databases on Server B.

On Server A, All the reporting Services settings are set to default. No other features are using & the Data source is ORACLE.

A user "ABC" is used to connect Oracle database and the option user name & password are stored securely in report server has selected.

On a application server C, in web.config file, provided the

url: http://servername/reportserver

Username: abc\RsReports

Password: xxxxxxxxx

Domain: abc

So from the application, any end user views the report from the application, internally that end user going to invoke the user abc\RsReports, and which in turn connects the Reporting server from there the oracle user ABC connects to ORACLE database and fethes the data for the report.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

That looks similar to what we are using. Meaning - we use the same kind of setup but different accounts obviously.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

pshaship SSCertifiable Points: 6125 More actions · Answer 5

We are using the same setup for SSRS and also seeing the blocking from report server. It's NOT from the PL/SQL code, but from report server on the SQL instance.

I wondering what will be the reason for blocking and I also read on some forums where they are telling blocking from report server is normal..

thanks

pshaship SSCertifiable Points: 6125 More actions · Answer 6

I went through the below link http://www.sqlservercentral.com/Forums/Topic795626-150-1.aspx

But I'm NOT considering to change ISOLATION level. Looking for other options

We also have the same problem. After analyzing the PL/SQL code, came to know that report is bringing large data and definetely we need to improve the query that report is using. But how this is related to Report Server blocking?

I did not understand why Report Server is blocking while the report is bringing data from Oracle database?

Thanks

klnsuddu SSCertifiable Points: 5836 More actions · Answer 7

I did not find a solution yet..I appreciate if anybody have the same problem and has a fix for this

Thanks

pshaship SSCertifiable Points: 6125 More actions · Answer 8

Did MS has some solution recommended for this reportServer blocking while running reports?

Thanks