Activity Monitor:

Previously we have this feature in management tab of sql server

Now it was moved to top of the SSMS

Or you can invoke using the at server level

I have ran below query to open a session

And I am opening the activity monitor, now we can see the processes and their information

We can kill the process from activity monitor also.

You can see the not only the processes, you can see below features also.

Please check and let us know if you have any concerns on this.

Thanks for viewing this.

Regards,

Chaitanya

Visit site: http://www.sqlblogging.com

Send an Email: sqlblogging@outlook.com