Topics: Data Access Application Block
Feb 19, 2010 at 3:00 PM

Im using SQL SERVER 2008 and Enterprise Lib 4.1. I notice when I executed a Store procedure"sp" with parameters the Enterprise Lib execute this sp "sp_procedure_params_100_managed" and then then my sp. The problem is the first time this sp is executed "sp_procedure_params_100_managed" take so much time, between 7 to 15 seconds to be executed, I checked the sql profiler. The result of all of this, is my app run slow the first time I executed the first sp with param.



Feb 22, 2010 at 7:18 AM


I'm not familiar with this one, anyways, does sp_procedure_params_100_managed always get called per execution of your sp?

Valiant Dudan
Global Technology and Solutions
Avanade, Inc.