"Leyva" <Leyva@discussions.microsoft.com> wrote in message
news:B0E4EA5F-D4D9-4A4D-BE41-0C93B3638300@microsoft.com...
> We are in the testing phase of report service; several time through this
> testing the end users experience performance issue (system come to a
> crawl).
> I'm new to sql server 2005 and have not been able to resolve performance
> issue. I have search several sites and have located several articles that
> apply to this issue be do not know which one I should try.
>
> when the slowness occurred this am I looked at activity monitor I can see
> locks for several ids.
>
> How do I find the root cause?

"Leyva" <Leyva@discussions.microsoft.com> wrote in message
news:B925B0C8-2940-4E17-A81E-B4B688A8DD48@microsoft.com...
> We are rendering to pdf. What should I set the memory to and how do I do
> this?
>
> "Bruce L-C [MVP]" wrote:
>
>> Look at your CPU and memory usage. RS does everything in memory. If you
>> are
>> rendering to PDF or Excel it can be very compute intesive. There is a big
>> different (order of magnitude) between HTML/CSV versus PDF/Excel.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Leyva" <Leyva@discussions.microsoft.com> wrote in message
>> news:B0E4EA5F-D4D9-4A4D-BE41-0C93B3638300@microsoft.com...
>> > We are in the testing phase of report service; several time through
>> > this
>> > testing the end users experience performance issue (system come to a
>> > crawl).
>> > I'm new to sql server 2005 and have not been able to resolve
>> > performance
>> > issue. I have search several sites and have located several articles
>> > that
>> > apply to this issue be do not know which one I should try.
>> >
>> > when the slowness occurred this am I looked at activity monitor I can
>> > see
>> > locks for several ids.
>> >
>> > How do I find the root cause?
>>
>>
>>

"Leyva" <Leyva@discussions.microsoft.com> wrote in message
news:8CE35988-C3CA-4125-8F35-E545DC85C031@microsoft.com...
> I'm not the developer so I will have to ask them the question about
> rendering
> to html. This server has 4GB of memory which I thought was more than
> plenty?
>
>
> "Leyva" wrote:
>
>> We are in the testing phase of report service; several time through this
>> testing the end users experience performance issue (system come to a
>> crawl).
>> I'm new to sql server 2005 and have not been able to resolve performance
>> issue. I have search several sites and have located several articles
>> that
>> apply to this issue be do not know which one I should try.
>>
>> when the slowness occurred this am I looked at activity monitor I can see
>> locks for several ids.
>>
>> How do I find the root cause?

"Leyva" wrote:

> We are in the testing phase of report service; several time through this
> testing the end users experience performance issue (system come to a crawl).
> I'm new to sql server 2005 and have not been able to resolve performance
> issue. I have search several sites and have located several articles that
> apply to this issue be do not know which one I should try.
>
> when the slowness occurred this am I looked at activity monitor I can see
> locks for several ids.
>