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: Today @ 11:09 AM
Points: 211, Visits: 1,111
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 11,194, Visits: 11,137
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