SQL Server's toolset is very rich and, when monitoring, we need to know which tool or tools we have to use to address performance issues and how to interpret the results measured by any certain tool. In this section, we will go through all native SQL Server tools that help us monitor the performance of SQL Server.
Tools for monitoring performance
Activity Monitor
Activity Monitor is a fast and relatively simple tool incorporated within Management Studio. It could be used for a fast overview of current activities running on the instance. As seen in the following screenshot, Activity Monitor is accessible from the popup menu called by right-clicking in Object Explorer at instance level:
The Activity Monitor window
In the...
