Hello Robert,

Rm> We have noticed that when running particularly laborious SQL statements
Rm> auto generated by Crystal reports FB (SS 1.5.1.4481) seems to go up to
Rm> 99% CPU utilization. When this occurs out FB application essentially
Rm> appears to come to a halt. At one users site 10 users freeze when
Rm> another user runs a report that takes about 15 minutes to run. Yes I
Rm> know the report is a problem but we have a number of other reports that
Rm> might take about a minute to run that potentially can cause the same
Rm> problem. It seems that FB isn't good at sharing its resources?

Rm> Is there a setting (max CPU utilization per SQL?) that can prevent this?

Have you tried ClassicServer instead of SuperServer? I had the same
problem (freezing) with IB6/FB-SS, and I've solved it moving to CS.


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com