Brad Wood wrote: > 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.
In case of PostgreSQL it has, though CF does not expose that information to the user. (See the BackendKeyData in the protocol definition: http://developer.postgresql.org/pgdocs/postgres/protocol-flow.html#AEN66410) > 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? Fix your stored procedures. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:256595 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
