There are a number of tools that you can use to monitor SQL Server Database Engine performance. These are explored in the following sections.
Activity Monitor is a tool in SQL Server 2014 Management Studio that gives you a view of current connections on SQL Server. You can use it to view information about the current processes and locks held on SQL Server resources. To open Activity Monitor in SQL Server Management Studio, right-click on the SQL Server instance name in Object Explorer and then select Activity Monitor.
To find blocked processes with Activity Monitor, use the following steps:
First click on Processes in Activity Monitor to open the Process Info page.
Then, locate the process that is waiting, scroll over to the Blocked By column, and note the process ID in that column.
Find this process ID on the Process Info page.
If you want to terminate the blocking process, right-click on it and choose...