I see. Thanks for the clarification on the Profiler stuff. Unfortunately, I don't MSSQL in front of me to play with it right now.
I give SeeFusion two thumbs way up on monitoring your SQL traffic and run times. (it incorporates a JDBC URL wrapper) I use a custom monitor I wrote for SQL server 2005 that gets the execution plans for me of my running SQL that I tied into the SeeFusion API. If I see a spike on the server, I can see who is doing it, what page they are on, what line of SQL is executing and what their execution plan is all at once. ~Brad ----- Original Message ----- From: "Gaulin, Mark" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, July 22, 2008 4:34 PM Subject: RE: cfquery and cfstoredproc > Hi Brad > Thanks for the links, those are interesting articles. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309489 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
