All geek questions in one place

Running stored procedures

What is the best way to find out which stored procedure is currently running in the database.

I have a stored procedure that basically calls the other 3 and passes them some parameters, and these 3 stored procedures take a long time to complete ... I would like to know which one works ...

thank

+3
source share
2 answers

I think you can also use SQL profiler to get more details.

+2
source

Activity Monitor , . Command , .

, , SQL- . , , .

SQL Server.

EDIT: SQL Profiler - , , , , , . IMO. , , .

. , .

+2

Source: https://habr.com/ru/post/1752595/

More articles:


All Articles