Sql Profiler Scan 开始执行存储过程
SqlServer是否必须启动Scan才能执行存储过程？
在 Sql Profiler 中，我可以看到：
- RPC 开始 ( exec sp_Edu3_SelectExamSession @ExamSessionId=N'AccessCode39361814' )
- Scan:Started
- Scan:Started
- Scan:Started
- RPC Completed ( exec sp_Edu3_SelectExamSession @ExamSessionId=N'AccessCode39361814' )
我能以某种方式看到发生了什么吗存储过程？在该 SP 中完成了不同的查询，但它们似乎没有出现在 Sql Profiler 中（也许我需要检查更多事件？）
Scan:Started 可能是 sp 中的查询进行的扫描？或不？
Does SqlServer has to start a Scan to execute a stored procedure?
In Sql Profiler I can see this:
- RPC Starting ( exec sp_Edu3_SelectExamSession @ExamSessionId=N'AccessCode39361814' )
- Scan:Started
- Scan:Started
- Scan:Started
- RPC Completed ( exec sp_Edu3_SelectExamSession @ExamSessionId=N'AccessCode39361814' )
Can I somehow see what's happening in the Stored Procedure? Different queries are done in that SP, but they do not seem to appear in Sql Profiler (maybe I need to check some more events?)
The Scan:Started are probably scans by the queries in the sp? Or not?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
当您启动探查器时，有一个模板，您可以在其中查看存储的过程逐行执行。它类似于内存中的“SQLProfilerTSQL_SPs”。
扫描事件可能关联，也可能不关联：这取决于您设置的过滤器。
When you launch profiler, there is a template where you can see stored proc line by line execution. It's something like "SQLProfilerTSQL_SPs" from memory.
The Scan event may be associated, it may not: it depends on the filters you have set.