Activity Monitor and Running Query – SQL in Sixty Seconds #115


Activity Monitor can come handy when you are in trouble as well. In this video, we will see how we can take the help of Activity Monitor to track Actively Running Query. If you are using SQL Server 2019, the feature described in this blog is by default enabled for you. However, if you are using any of the previous versions of the SQL Server (2016, 2017), you will have to use the trace flag to enable the feature discussed today.

In the previous blog post, I discussed how Live Query Statistics can be handy and helpful. I got lots of