SQL Server Performance

sp_prepare Vs sp_prepexec

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by n8ken, Nov 20, 2009.

  1. n8ken New Member

    I want to know the difference between sp_prepare and sp_prepexec in term of performance.
    Jtds : sp_prepare + sp_exec in batch
    Microsoft jdbc : sp_prepexec + sp_exec in batch
    I use Jdbc driver of Microsoft (the last) and Jtds. For my processes, there are this difference and the microsoft driver seems to have less batch processing than Jtds. Is it correct and have an idea of the best performance :
    sp_prepare + sp_exec with large batch or sp_prepexec + sp_exec with few batch.
  2. FrankKalis Moderator

    Have you found a workaround in the meantime?

Share This Page