- Because that stored procedure is executed inside a stored procedure. Stored procedure executed inside a stored procedure is not hit by SQL profiler (?)
- Because that stored procedure is executed inside a stored procedure. Stored procedure name is passed to this SP as an input parameter and that SP is not hit by SQL profiler (?)
- Because no stored procedure is called. Work was done by executing SQL query directly.
- Because that stored procedure is called by a job, not at the moment you did profiling
Leave a Reply