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: Thursday, September 18, 2014 11:12 AM
Points: 212, Visits: 1,116
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: Today @ 10:07 AM
Points: 9,923, Visits: 11,170
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