SQL Server 2017 CU6 Enterprise. Is there a way to monitor and alert on running stored procedures on specific database if more than - say two minutes - has passed - but, while it is still running. I know multiple resources exist to capture that after it was done - e.g. xEvents, QueryStore, .. - but I need to capture that while stored procedure is still running and then write to eventlog or sending email with powershell or else.
Thanks.
For this I would use Adam Mechanic's sp_WhoIsActive.
This well documented procedure is a go-to in the community to see what is running on your server. By default, it doesn't return sleeping SPIDs.
To capture the results, check out this part of the documentation.
You will also want to limit it to a specific database or host or whatever. For that, Check out deciding what not to see.
You can find all of the help by running sp_WhoIsActive @help = 1 or just reading the full docs.
