Ok, I have a partial answer to my question. Since I use MSSQL Server, this is good enough for me. Apparently the drivers for MS SQL do report the spid. For you SeeFusion users out there, do this to see your spid:
Add ";dialect=sqlserver" as a SeeFusion JDBC URL parameter (at the end, outside of the curly braces) and it should start reporting SPID along with the query. I tried it and it works beautifully. ~Brad -----Original Message----- From: Brad Wood Sent: Thursday, October 12, 2006 3:43 PM To: CF-Talk 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:256592 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
