Hi Gert
Getting the SQL from the front-end side is nice, but not sufficient for
profiling.
The trick is getting the original query text through the JDBC layer and into
SQL Server, where the profiler can see it. I was thinking that maybe SQL could
be captured as a comment, along with the "exec sp_execute 162, 5909, 1973"
stuff.
Thanks
Mark
-----Original Message-----
From: Gert Franz [mailto:gert.fr...@railo.ch]
Sent: Thursday, February 12, 2009 10:58 AM
To: cf-talk
Subject: AW: (ot) More SQL Profiler questions
Well in Railo in the debugging info you always get the queries without any
Questionmarks... Even if you use CFQUERYPARAM.
Gert
-----Ursprüngliche Nachricht-----
Von: Gaulin, Mark [mailto:mgau...@globalspec.com]
Gesendet: Donnerstag, 12. Februar 2009 15:26
An: cf-talk
Betreff: RE: (ot) More SQL Profiler questions
...and now you know why I don't like cfqueryparam...
As far as I can tell there is no way for you to translate that "162"
into the actual sql that it corresponds to since the id "162" is
specific to the database connection. (You can look around at prepared
statements by querying syscacheobjects, but it will hard to know for
sure which item it is. Check out
http://www.megasolutions.net/Sqlserver/How-can-I-find-out-what-command-s
p_execute-is-running-(without-using-Profiler)-1687.aspx for more ideas.)
I've submitted several ideas for enhancements to Adobe/macromedia on how
they could help this situation, for whatever good that has done. (None,
I suppose.)
Thanks
Mark
-----Original Message-----
From: Rick Root [mailto:rick.r...@webworksllc.com]
Sent: Wednesday, February 11, 2009 5:57 PM
To: cf-talk
Subject: (ot) More SQL Profiler questions
Alright so now that I'm back to using the regular SQL Server JDBC
driver, my queries are flying. Most of them. Problem is, there are
some that don't.
Watching in SQL Provider, all I see is stuff like this:
exec sp_execute 162, 5909, 1973
That took 956ms of cpu... did over 180,000 reads, and took nearly 10
seconds to run.
And I have NO idea what the query is or how to find out what it was.
I wasn't running the trace when the statement was prepared so all I know
is that the "ID" of the prepared statement is "162"
Anyone dealt with this before?
--
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319237
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
