Multi-TIFF generation slows down server

We have reports that render as tifs. The reports are called in batch
rendering any where from a few times to a few hundred times. The report was
on server A and got its data from server A and server B. After repeated
complaints and slowness, we moved the reports to server C. Server C is now
slow. The slowness starts when reports are rendered and then continues on
long past the end of the batch, in fact it requires a reboot to fix. This
behaviour seems to follow the report. Are there any known issues causing a
memory leak? Servetr performance seems low in terms of disk utilization and
processor utilization.On Mar 27, 5:45 pm, Jeff Ericson
<JeffEric...@.discussions.microsoft.com> wrote:
> We have reports that render as tifs. The reports are called in batch
> rendering any where from a few times to a few hundred times. The report was
> on server A and got its data from server A and server B. After repeated
> complaints and slowness, we moved the reports to server C. Server C is now
> slow. The slowness starts when reports are rendered and then continues on
> long past the end of the batch, in fact it requires a reboot to fix. This
> behaviour seems to follow the report. Are there any known issues causing a
> memory leak? Servetr performance seems low in terms of disk utilization and
> processor utilization.
Known issue fixes for SP 2 are listed here: http://support.microsoft.com/kb/921896.
It seems that the majority of the recent issues w/performance are w/
Analysis Services (though there are a couple others mentioned). I
would think that accessing outside applications in bulk would have
this type of affect in general though. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||All rendering is done in RAM. I am not familiar either with the TIFF
rendering but PDF is much slower than HTML so it doesn't surprise me that
TIFF is. Have you tried using PDF instead (or even better, html). PDF
rendering has improved in 2005 versus that in 2000 product.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jeff Ericson" <JeffEricson@.discussions.microsoft.com> wrote in message
news:B7379ECE-65A1-41C2-8C85-DB7F8DEDCCA7@.microsoft.com...
> We have reports that render as tifs. The reports are called in batch
> rendering any where from a few times to a few hundred times. The report
> was
> on server A and got its data from server A and server B. After repeated
> complaints and slowness, we moved the reports to server C. Server C is
> now
> slow. The slowness starts when reports are rendered and then continues on
> long past the end of the batch, in fact it requires a reboot to fix. This
> behaviour seems to follow the report. Are there any known issues causing
> a
> memory leak? Servetr performance seems low in terms of disk utilization
> and
> processor utilization.