CFMX7 SQL 2000 DeadLocks

[jeff_gombala]

After putting CFMX 7 live on our production server we immediately began seeing
deadlocks on the MS SQL server that we did not see when running CF 5. The CPU
utilization on both servers would immediately spike to 100% no matter what kind
of query or stored procedure was ran. We have tried both versions of the JDBC
drivers, the one that ships with CFMX 7 and the updater, and we have tried the
jTDS driver... all produce the same result.

Any help, thoughts, insight on CFMX tuning or performance monitoring would be
appreciated.

[jeffrows@gmail.com]

Found the answer to my issue, CFMX 7 Updater 3 seems to take care of
the situation. We also ended up using JRUN and JNDI datasources.

[gclausen]

If you are using Client Variables you may want to install the latest CFMX 7 hotfix [url]http://www.macromedia.com/go/fd71533[/url]

[cfoster]

Did the hot fix take care of the problem? We have been having the same problem
these past couple weeks, ever since upgrading our CFMX6.1 server to 7, and
we've installed all the latest updaters and hot fixes. Any troubleshooting
ideas would be greatly appreciated!

[saltech]

I was having similar deadlock errors but changing few things have helped me
reduce them to almost Nil. I would recomed fine tuning you server based on the
your load. Thats what I have changed.

1. First of all I have applied all the hotfixes available out there. Specially
(Updated DataDirect JDBC drivers (version 3.5) )
2. Changed the Maximum number of simultaneous requests to 6. (On a Dual
Processor)
3. Changed the Timeout Requests after ( seconds ) 30.
4. Changed the Maximum JVM Heap Size (MB)1024. (Total Server Memory 2Gig)
5. Disabled the Disable global client variable updates.

See if this helps.