Initiate debugging of a stored procedure with user defined values for input parameters.

List the dependent objects called by the profiled procedure.

This feature is helpful to break running code based on user defined conditions such as errors, excessive rowcount or connections.

With Lazy Debugging, ApexSQL Debug executes your stored procedure and logs everything that happens during execution. A report will be generated containing a list of all executed steps, how long each step took, what variables were changed, etc. You can export the results to PDF or Excel.

View the contents of a temp table during debugging.

User defined values can be set for procedure parameters prior to profiling.

Profiling reports show a sophisticated analysis of the procedures processing results including performance by line, and before and after results of parameter values.

The ApexSQL Profiler provides a high level view of procedure performance allowing you to quickly view things like the slowest statements.

View T-SQL performance by processing time. Visually recognize slow running statements.

View T-SQL performance in user-friendly table-like dialog. Different metrics can be grouped and sorted helping you identify bottlenecks within your stored procedure call stack, so that you can optimize your stored procedures accordingly.

View update history of a variable/parameters used in the procedure. Visually detects what and where change occurs.