Hey Brad, A good DBA should easily be able to tell what SQL processes are causing locks / long processing time etc. A quick look should show you the offending process. Are you on MSSQL? Is your DBA MCDBA?
This is bread and butter stuff for a DB , certainly on SQL Server. Though I would be worried you have these endless loops, maybe you need to re-factor the offending code? N "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Brad Wood To: CF-Talk Sent: Thu Oct 12 21:43:06 2006 Subject: do cf database calls return spid The answer to this question may vary by database, but does anyone know if CF has access to the spid being used by the database server to process by query or stored proc. Usually the scenarios will go something like this: I will get notified about a really long page request going on by SeeFusion. I will look at that request and see it is hung on a really long-running proc which is probably in an endless loop (we have a few of those). I don't want to kill the page with SeeFusion, because the database would still be running, but SeeFusion doesn't tell me what spid is being used. That makes it harder for my DBA to find the right spid to kill, since there could be over a dozen spids from that particular web server running at the same time. Any ideas/suggestions? Thanks! ~Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256593 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
