May 20, 2009 at 3:38 am
Hi,
When I open activity monitor to see locks , in the process info tab
I see process ids. but the query i am getting is
sp_prepexec;1, or master..xp_jdbc_commit2;1
sp_execute;1
I am not able get any info out of this, what does this indicate?
Thanks
May 20, 2009 at 1:28 pm
I think these are results of precompiled queries that are coming from you front-end application that is written with object-mapping database querying tool like Hibernate. You’d better ask your developers what they are using. More on Hibernate you can find on http://en.wikipedia.org/wiki/Hibernate_Query_Language and other resources. Is that helpful?
Alex Prusakov
May 24, 2009 at 5:48 am
It seems that the application is using a prepare/execute model - where a query is prepared once and then executed one or more times with different parameters later on. You can generally pick up more information by tracing a particular connection that is using this model, and the correlating the various calls. Typically, the prepare contains the statement text, and a handle is returned by SQL Server to allow the app to execute the query again without specifying the full text. This is quite an old approach, used in attempt to promote re-use of plans IIRC.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply