开发者

sp_procedure_params_managed - how to eliminate these calls from EnterpriseLibrary?

We noticed in a SQL Server Profiler trace that this proc is being called:

sp_procedure_para开发者_开发技巧ms_managed

Each call has 350+ reads in the trace!

We are using Microsoft.Practices.EnterpriseLibrary.Data in an ASP.NET front end.

How can we eliminate these stored procedure calls? We are not explicitly calling it in code.

I'm running Sql Server 2005 and Enterprise library 3.1.0.0.


sp_procedure_params_managed is used determine the stored procedure parameters. I guess the Microsoft.Practices.EnterpriseLibrary.Data uses it to determine what the parameters are for the stored procedure call. It will probably cache the results to prevent extra overhead.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜