What is Active

The what is active report is handy to see what is running right now on our SQL Server. It checks for anything that is running for longer than half a second to filter out those really quick queries.

When working on a server that is overloaded and not keeping up, this list of active queries will continue to grow and grow. On a fast running server you will generally see nothing, or just a few queries on the list.

To get to the What is Active report, you can get there from the Server Overview page.

The what is active report is part of the instance level reports in Database Health Monitor.