Web server is slow when CR 8.0 withlong running procedure is fired

[HariPR]

We are using Crystal Report 8.0, Sql Server 2000. All reports are launched from web server (asp code)
The Crystal Report 8.0 is installed in the Web server and some times the web server is slow when long running stored procedures are excecuted in the report. This creates a cascading effect and we are forced to restart the web server. We observed that this happens only if reports with long running query is fired.
Also if the user closes the report window even before the report is renderd then the web server is slow. We could see all stored procedures in the SQL Server 2000 (sp_who) piled up.
I suspect that Crystal Report is a single threaded and all requests are queued up. And if some user closes a window even before the report is rendered then all further report launched are slow and creating a cascade effect to slow down the web server (IIS).

 

[Turkbear]

Hi,
Yes - CR, like most Windows apps, is single-threaded and can cause the entire IIS server to be unresponsive, not just the Report.

By 'installed in the Web Server' do you mean that you are running the Pageserver and webcomponent services?

These are also single-threaded and are notoriously bad with long running reports.

If possible upgrade to CE10 and gain real control over your reports and performance.