Report Viewer Slow to Render Simple Reports

[Kerry]

Hi I'm using the ReportViewer.Winform control verions 8.0.0.0 runtime version
2.0.50727 in my C#.NET client app. I'm experiencing extremely slow
performance rendering simple reports 35sec. I'm using 'Remote' Processing
mode, when I step through my code everything is fine until the
SetParameters() method of the ServerReport class. I've tried ensuring the
IIS does not unload the worker process by setting the idle timeout to 8hrs
but still the first hit to the server is slow and subsequent hits are slow
too (maybe slightly faster at 30sec). When I access the report outside of
ReportViewer ie. from the RS Web interface the report renders in 2sec fine.

Any suggestions please?

[Jeje]

it's certainly a network issue, specially a name resolution issue.
do you have 2 different servers?
verify how you reference your RS server (by DNS name, netbios name or IP
address)
try to use the basic authentication to see if there is a difference. (if
yes, it's an authentication issue also related to the network settings, the
server as problems to identify the active directory server)
make sure that the primary DNS server of the IIS server is the domain
controller.
use the netdiag tool to idenfity possible issues.

"Kerry" <Ke...@discussions.microsoft.com> wrote in message
news:DCD5A513-C9FD-41BD...@microsoft.com...

[Mark Essex]

Any chance you are using SQL EXPRESS Edition for this?

We are seeing significant performance differences for the Reporting Services
that installs with Express versus the same DB/Reports going against a
Reporting Services instance (same machine, etc) with Developer Edition.

We are still investigating, but seeing BIG differences, but not sure why.
It isn't SQL Express that's the issue, because if I run the DEVELOPER
edition Reporting Services Dataset to connect to the SQL Express database,
it is still very fast, but as soon as I run with the Express Edition of
Reporting SErvices, it slows way down.

One example - report renders in 2-3 seconds on Developer Ed. takes 15-20
seconds (every time) on Express.

Mark

"Kerry" <Ke...@discussions.microsoft.com> wrote in message
news:DCD5A513-C9FD-41BD...@microsoft.com...

[Kerry]

Hmm! we are also running developer edition from SQLServer 2005 IIS6 server
and SQLServer 2005 server, I'll need to install standard version of the
environment on separate servers (lot of work) to see if there is a
difference...thanks for the tip.