Poor performance when accessing reports through URL

When viewing reports through the ReportServer application, I typically can
get response times that are between 5 and 10 seconds for my reports (in pdf
format). However, when I attempt to just view the report directly using a URL
(with the appropriate arguments supplied), the reponse time is usually 3 or 4
times worse, and it seems to eat up more resources. Is accessing reports
through a URL somehow doing something different? Anyone else experience this?
Any help would be appreciated.When you use Report Manager you are not getting the report as PDF. You are
getting them as HTML. Then through URL you can get them as PDF or HTML (your
choice). PDF and Excel formats are much much slower than HTML and are much
more resource intensive.
Try your URL as html (if you leave off the rendering format it defaults to
HTML).
You should not be seeing a difference if the format is the same with both. I
suspect that you are rendering in different formats.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"blabore" <blabore@.discussions.microsoft.com> wrote in message
news:EECE8772-5AEA-40F1-AE63-AA9A409A4646@.microsoft.com...
> When viewing reports through the ReportServer application, I typically can
> get response times that are between 5 and 10 seconds for my reports (in
> pdf
> format). However, when I attempt to just view the report directly using a
> URL
> (with the appropriate arguments supplied), the reponse time is usually 3
> or 4
> times worse, and it seems to eat up more resources. Is accessing reports
> through a URL somehow doing something different? Anyone else experience
> this?
> Any help would be appreciated.|||Bruce,
Thanks for the response. I probably wan't clear in my first post. To make
sure I was comparing apples to apples, I used the export functionality in the
report server to get a PDF. The time to complete the export was approximately
6 seconds, while when I attempted to do the same through a URL, it was over
20. To be sure that the time used to load Acrobat Reader doesn't affect
anything, I don't even have it installed, which just forces IE to download
the file. It seems odd, since the web serivce should be used no matter.
What I've found is that when I use slashes in the URL (instead of esacping
them), it significant slows things down. Is this a known issue?
"Bruce L-C [MVP]" wrote:
> When you use Report Manager you are not getting the report as PDF. You are
> getting them as HTML. Then through URL you can get them as PDF or HTML (your
> choice). PDF and Excel formats are much much slower than HTML and are much
> more resource intensive.
> Try your URL as html (if you leave off the rendering format it defaults to
> HTML).
> You should not be seeing a difference if the format is the same with both. I
> suspect that you are rendering in different formats.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "blabore" <blabore@.discussions.microsoft.com> wrote in message
> news:EECE8772-5AEA-40F1-AE63-AA9A409A4646@.microsoft.com...
> > When viewing reports through the ReportServer application, I typically can
> > get response times that are between 5 and 10 seconds for my reports (in
> > pdf
> > format). However, when I attempt to just view the report directly using a
> > URL
> > (with the appropriate arguments supplied), the reponse time is usually 3
> > or 4
> > times worse, and it seems to eat up more resources. Is accessing reports
> > through a URL somehow doing something different? Anyone else experience
> > this?
> >
> > Any help would be appreciated.
>
>|||Also, not sure if you are really comparing apples to apples. When you export
you get the report you are currently looking at. This means it uses the data
that it has already retrieved at the server. So the export would not have
the data retrieval time from whatever database you are hitting. There might
be some other differences as well.
The only other thing I can think of is authorization of the user. Could be
that this is taking some time.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"blabore" <blabore@.discussions.microsoft.com> wrote in message
news:238C6980-AD52-4CFF-BD67-84408CEE5263@.microsoft.com...
> Bruce,
> Thanks for the response. I probably wan't clear in my first post. To make
> sure I was comparing apples to apples, I used the export functionality in
> the
> report server to get a PDF. The time to complete the export was
> approximately
> 6 seconds, while when I attempted to do the same through a URL, it was
> over
> 20. To be sure that the time used to load Acrobat Reader doesn't affect
> anything, I don't even have it installed, which just forces IE to download
> the file. It seems odd, since the web serivce should be used no matter.
> What I've found is that when I use slashes in the URL (instead of esacping
> them), it significant slows things down. Is this a known issue?
> "Bruce L-C [MVP]" wrote:
>> When you use Report Manager you are not getting the report as PDF. You
>> are
>> getting them as HTML. Then through URL you can get them as PDF or HTML
>> (your
>> choice). PDF and Excel formats are much much slower than HTML and are
>> much
>> more resource intensive.
>> Try your URL as html (if you leave off the rendering format it defaults
>> to
>> HTML).
>> You should not be seeing a difference if the format is the same with
>> both. I
>> suspect that you are rendering in different formats.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "blabore" <blabore@.discussions.microsoft.com> wrote in message
>> news:EECE8772-5AEA-40F1-AE63-AA9A409A4646@.microsoft.com...
>> > When viewing reports through the ReportServer application, I typically
>> > can
>> > get response times that are between 5 and 10 seconds for my reports (in
>> > pdf
>> > format). However, when I attempt to just view the report directly using
>> > a
>> > URL
>> > (with the appropriate arguments supplied), the reponse time is usually
>> > 3
>> > or 4
>> > times worse, and it seems to eat up more resources. Is accessing
>> > reports
>> > through a URL somehow doing something different? Anyone else experience
>> > this?
>> >
>> > Any help would be appreciated.
>>

Pls help me

Hi
I had windows integrated authication in directory
security in both folder reports and reportserver.
But I need reportserver as normal asp page so I just
changed to allow annoynymus access to reportserver folder.
So any once can access report using specifi url and it's
working without any problem.
But funny part is when I access
http://servername/reports (and logged in as administrator)
It doesnt show anything. Before that It was showing my
report and I could change and configure my report.
Please note that I didnt change any security setting in
reports folder and only thing I changed was allowing
annoynymus access to reporserver folder.
Any help would be grateful
Thanx
KenWhen you configure the Report Server for anonymous access, it will see the
requests coming under the anonymous account (IUSR_<computer name>) which
most likely doesn't have access to the report catalog in your case.
I would recommend you reconsider the Anonymous access strategy. When
Anonymous access is enabled, the Report Server won't be able to
differentiate the users which IMO is a recipe for a total chaos.
Not sure what you mean by I need reportserver as normal asp page.
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
www.manning.com/lachev
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:212b601c45a4c$15af4980$a101280a@.phx.gbl...
> Hi
> I had windows integrated authication in directory
> security in both folder reports and reportserver.
> But I need reportserver as normal asp page so I just
> changed to allow annoynymus access to reportserver folder.
> So any once can access report using specifi url and it's
> working without any problem.
> But funny part is when I access
> http://servername/reports (and logged in as administrator)
> It doesnt show anything. Before that It was showing my
> report and I could change and configure my report.
> Please note that I didnt change any security setting in
> reports folder and only thing I changed was allowing
> annoynymus access to reporserver folder.
> Any help would be grateful
> Thanx
> Ken
>

Please help.. can't find how to administer userr accounts

I'm trying to administer permissions for other users so that reports can be
viewed remotely.
I'm told to go to http://myserver/reportserver but I get this error: The
permissions granted to user 'MyServer\IUSR_MyCompany' are insufficient for
performing this operation. (rsAccessDenied)
I'm told to go to http://myserver/reports and I do get a SSRS home page but
nothing on it to do anything with.
I'm told to launch SS Mgmt Studio, go into Reporting Services and
right-click on the Home folder and click Properties. I do this but then
there's nothing in there for me to work with.
Can anyone please tell me what's going on and how I can get in and
andminister user permissions?
Thanks for any help!
RonIt sounds to me like one of two things. Either you web has anonymous turned
on. If so, then all users are anonymous and no user can administer the
website.
Two, anyone who is in the local administrators group of the server can
administer RS. Are you a member of that group?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ronald S. Cook" <rcook@.westinis.com> wrote in message
news:u2JLWqaWHHA.3568@.TK2MSFTNGP06.phx.gbl...
> I'm trying to administer permissions for other users so that reports can
> be viewed remotely.
> I'm told to go to http://myserver/reportserver but I get this error: The
> permissions granted to user 'MyServer\IUSR_MyCompany' are insufficient for
> performing this operation. (rsAccessDenied)
> I'm told to go to http://myserver/reports and I do get a SSRS home page
> but nothing on it to do anything with.
> I'm told to launch SS Mgmt Studio, go into Reporting Services and
> right-click on the Home folder and click Properties. I do this but then
> there's nothing in there for me to work with.
> Can anyone please tell me what's going on and how I can get in and
> andminister user permissions?
> Thanks for any help!
> Ron
>
>
>
>|||Thanks Bruce.. I'll check those things. I appreciate the help.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23WO9KwaWHHA.388@.TK2MSFTNGP04.phx.gbl...
> It sounds to me like one of two things. Either you web has anonymous
> turned on. If so, then all users are anonymous and no user can administer
> the website.
> Two, anyone who is in the local administrators group of the server can
> administer RS. Are you a member of that group?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ronald S. Cook" <rcook@.westinis.com> wrote in message
> news:u2JLWqaWHHA.3568@.TK2MSFTNGP06.phx.gbl...
>> I'm trying to administer permissions for other users so that reports can
>> be viewed remotely.
>> I'm told to go to http://myserver/reportserver but I get this error: The
>> permissions granted to user 'MyServer\IUSR_MyCompany' are insufficient
>> for performing this operation. (rsAccessDenied)
>> I'm told to go to http://myserver/reports and I do get a SSRS home page
>> but nothing on it to do anything with.
>> I'm told to launch SS Mgmt Studio, go into Reporting Services and
>> right-click on the Home folder and click Properties. I do this but then
>> there's nothing in there for me to work with.
>> Can anyone please tell me what's going on and how I can get in and
>> andminister user permissions?
>> Thanks for any help!
>> Ron
>>
>>
>>
>>
>