Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sp_prepexec calls from Hibernate Technology and Performance Impact! Expand / Collapse
Author
Message
Posted Tuesday, May 22, 2012 8:42 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 7:49 AM
Points: 212, Visits: 1,117
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!
Post #1304215
Posted Wednesday, May 23, 2012 12:29 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, November 20, 2014 7:53 PM
Points: 9,928, Visits: 11,194
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
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1304711
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse