Let us continue our question of the day series with day twenty-five.

What is the activity monitor in SQL Server?

Activity monitor is a built-in monitor that provides information about the process, resource waits, data file input/output, and recent expensive queries that involve the current instance of SQL Server.  It also gives you a small graphical representation of the monitoring as shown below.

Enjoy!