Performance tuning

[Jami]

Hi all,
I am developing a number of sites using ColdFusion on a Unix box. I am experiencing a large number of warnings reading:
"Timed out while waiting for thread semaphore". These are consistent and are at times even crashing the server.

From what I can gather, there is probably bad script or a bad database connection (we are connecting to an Oracle database) within one of our sites. I am not sure where to go to pinpoint this though. Isn't there a CF performance monitor or some error checking function I can use? I am totally clueless as to where to turn, as no errors are being generated in the application log that correspond with these thread warnings in the server log. Also, can anyone help me monitor these threads that may be hanging?

Thanks!
Jami

 

[crusader]

Jami,
I did a Search in my CF documentation and found this:
It is Windows based but if you do a search under CF studio for performance monitor (with your unix version) you should get something more appropriate!
(hope this helps)

ColdFusion provides a set of counters for monitoring the performance of the ColdFusion Server. This allows you to use the Windows NT performance Monitor administration utility to monitor ColdFusion performance. This enhancement to NT performance Monitor is installed automatically by the ColdFusion setup.

A Windows NT performance Monitor configuration file has been added to ColdFusion for Windows systems that is pre-configured to monitor ColdFusion Server activity. The performance Monitor configuration file, ColdFusionServer.pmc is installed in cfusion\bin.

To monitor ColdFusion Server activity, click on the ColdFusion performance Monitor icon in the ColdFusion Server Program group. You can also open the performance Monitor utility and then open the cfusion/bin/ColdFusionServer.pmc file.

ColdFusion counters available
ColdFusion supports 11 different counters you can enable in the Windows performance Monitor:

Average database transaction time
Average queue time
Average request time
Bytes incoming per second
Bytes outgoing per second
Database hits per second
Page hits per second
Cache pops per second
Number of queued requests
Number of running requests
Number of timed out requests
To enable the performance Monitor for ColdFusion:

Open the ColdFusion Administrator to the Miscellaneous Debugging page.
Click the Enable performance monitoring option. The default is off.
Click Apply to save the new setting.
To configure the performance Monitor:

From the Windows Start menu, select Programs > Administrative Tools > performance Monitor.
In the performance Monitor, select Edit > Add to Chart or File > Open to open an existing chart.
In the Add to Chart dialog, select ColdFusion Server from the Object drop-down list. You can change any of the display options (Color, Scale, Width, Style) for a counter before adding it.

Click one or more selections in the Counters list, then click the Add button. The counters are listed at the bottom of the Chart View.
Click the Explain button to display embedded help for the selected counter.