SQL Server Profiler - Why are some calls RPC:Completed and Some Calls SQL:BatchCompleted

SQL Server Profiler - Why are some calls RPC:Completed and Some Calls SQL:BatchCompleted

BatchCompleted means TSQL code (e.g. selects) have completed.

RPC:Completed means stored proc has completed. It could be that EF executes SQL code dinamically using sp_executesql so you get RPC:Completed.

sp_executesql 本身是一个存储过程

 

posted @ 2021-05-18 14:32  ChuckLu  阅读(88)  评论(0编辑  收藏  举报