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:256585 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
