Hi Rick
That's a good trick with MaxPooledStatements...
Say, what was the deal with going "back to using the regular SQL Server
JDBC" and "my queries are flying"?
Thanks
Mark
-----Original Message-----
From: Rick Root [mailto:[email protected]]
Sent: Thursday, February 12, 2009 10:04 AM
To: cf-talk
Subject: Re: OT: More SQL Profiler questions
In case anyone else comes across this via google...
Once a query is compiled with sp_prepare, it is stored in a system table
however only the first 128 characters of the SQL are stored in a visible
form in SQL 2000....
The easiest way to handle this was to set MaxPooledStatements to 0 while
running SQL Profiler. On my system, it did cause a very slight
degradation in performance due to having to prepare every statement..
but helped me to actually see the query being run and allowed me to
debug the ones with large amounts of reads, high duration, high cpu,
etc.
Rick
On Wed, Feb 11, 2009 at 5:57 PM, Rick Root <[email protected]>
wrote:
> 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:319232
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
