I have a slow unit test (defined as a SQL script) executing stored procedures nested in other stored procdedures.
I'd like to know if SQL Server Profiler provides tracks for execution along the 'call stack' at different nesting levels.
Using SQL Server Profiler to Track Nested Stored Procedure Performance
profilersql serversql-server-2016
Related Question
- Sql-server – How to reliably track stored procedure ( and functions ) use over time
- Execute Stored Procedure Remotely Using Linked Server
- Sql-server – Why does SQL Server Profiler trace not capture SELECT operator in execution plans
- Sql-server – SQL Server 2016 Nested JSON Array
- Sql-server – How to use SQL Profiler to capture a single stored procedure
- SQL Server – How to Generate Execution Plans for Dynamic SQL Queries in Stored Procedures
Best Answer
I got the answer in the meantime - sorry for the inconvenience
in profiler settings it is possible to select all events from there a list is provided and some settings can be checked to tracks for SP execution