Sql Profiler Scan Started to execute a stored procedure

Posted by Lieven Cardoen on Stack Overflow See other posts from Stack Overflow or by Lieven Cardoen
Published on 2010-03-14T14:56:08Z Indexed on 2010/03/14 15:25 UTC
Read the original article Hit count: 308

Filed under:

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?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sqlprofiler