Prev: Custom Code execution on Table
Next: HELP!
From: DB on 29 Mar 2010 16:41
We upgraded our Reporting Services 2005 to Reporting Services 2008 over the
weekend. All of our reports are slow to load. It is not just when the
report goes to pull data, but as soon as you clink on the link to the report.
It takes 30 sec to a min just to get to where the report wants to load data.
All reports do this so I don't think it is SQL related, i.e. queries. Is
there a setting somewhere to optimize report loading in the config file?
--
DB
From: Uri Dimant on 30 Mar 2010 09:17
DB

Perhaps running update statistics on Report Server databases


"DB" <DB(a)discussions.microsoft.com> wrote in message
news:0C11BC90-D9ED-4A88-8887-B294AB0EE3B0(a)microsoft.com...
> We upgraded our Reporting Services 2005 to Reporting Services 2008 over
> the
> weekend. All of our reports are slow to load. It is not just when the
> report goes to pull data, but as soon as you clink on the link to the
> report.
> It takes 30 sec to a min just to get to where the report wants to load
> data.
> All reports do this so I don't think it is SQL related, i.e. queries. Is
> there a setting somewhere to optimize report loading in the config file?
> --
> DB


From: DB on 31 Mar 2010 10:46
We had some weird runaway transactions. A server restart fixed our problem.

--
DB


"Uri Dimant" wrote:

> DB
>
> Perhaps running update statistics on Report Server databases
>
>
> "DB" <DB(a)discussions.microsoft.com> wrote in message
> news:0C11BC90-D9ED-4A88-8887-B294AB0EE3B0(a)microsoft.com...
> > We upgraded our Reporting Services 2005 to Reporting Services 2008 over
> > the
> > weekend. All of our reports are slow to load. It is not just when the
> > report goes to pull data, but as soon as you clink on the link to the
> > report.
> > It takes 30 sec to a min just to get to where the report wants to load
> > data.
> > All reports do this so I don't think it is SQL related, i.e. queries. Is
> > there a setting somewhere to optimize report loading in the config file?
> > --
> > DB
>
>
> .
>
 | 
Pages: 1
Prev: Custom Code execution on Table
Next: HELP!