Martin,

NT error 232 means "The pipe is being closed"
This is a problem with connecting to your database. Or rather not staying
connected to the database.  The reason that your database server is low on
cpu utilisation is because it isn't doing anything, because the connections
to the database are being continually dropped.  Generally the solution for
this is check that you have the latest version of MDAC installed on your
server.  However, you're running win2k, so you should already have the
latest drivers on there already.  Worth a check though....

Otherwise,  40 queries on a page!!!!!  Is that every page or just one or
two?  I would suggest that maybe your application needs some performance
tuning.  Look at how those queries could be reduced in number, avoid using
query of query, most QofQ stuff can be better done using appropriate JOINs
in SQL therefore making the database work for its money and not CF, look at
using stored procedures and caching your queries.

Sorry to not have a more immediate solution.

Regards

Stephen
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with 
'unsubscribe' in the body or visit the list page at www.houseoffusion.com

Reply via email to