sp_prepexec calls from Hibernate Technology and Performance Impact!

• Abrar Ahmad_

  SSCarpal Tunnel

  Points: 4248

  More actions

  May 22, 2012 at 8:42 am

  #258520

  [font="Verdana"]Hi all,

  What performance impact the SP_PREPEXEC cause and why should it be avoided? Do we can quantify the impact?

  Any findings please 🙂

  Thanks![/font]

• Paul White

  SSC Guru

  Points: 150468

  More actions

  May 23, 2012 at 12:29 am

  #1491560

  This is a generally a performance optimization, see the following links for more information:

  http://www.sqlservercentral.com/articles/sp_prepexec/76511/

  http://msdn.microsoft.com/en-us/library/ff848812.aspx

  http://jtds.sourceforge.net/apiCursors.html

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi