How to check SP call trace live in SQL Server ?

You can also achieve this through stored procedures debugging in SQL Server Management Studio.

The Call Stack, as the name suggests, displays the stack of calls that have been executed up to the current point in store procedure. There are excellent features though this can achieve through Local Window, Watch Window, Immediate Window and Breakpoints. For more detial please check below URL.

https://www.sqlshack.com/debugging-stored-procedures-sql-server-management-studio-ssms/

+2

Sachin Singh4y ago

Yes, nothing better than SQL profiler, with the constraint that you have access to it if it is a remote connection.

+2

Nitin Sontakke4y ago

Not sure what level of details you expect to see.

However, if you just want to see what requests SQL Server receiving from what all connections with query text, stored procedure names, and their parameter values, you can use Profiler.

A tool integrated within SQL Server Management Studio itself. Tools -> SQL Server Profiler

Hope it helps.

+2