 | Note: Ensure that you are logged in using the AgfaService account; you cannot log into SQL Server Management Studio using the Administrator account. |
You can view all the processes currently running in the database and check whether any of the processes are being blocked by other processes or are blocking other processes.
To monitor SQL 2008 database activities
Open SQL Server Management Studio.
On the SQL Server Management Studio standard toolbar, click Activity Monitor.
In the Connect to Server dialog, select the server name of the SQL Server that the program is running on and the authentication mode and then click Connect.
You can also open Activity Monitor at any time by pressing Ctrl+Alt A.
In the window that appears, check process info.
To see whether any of the processes are being blocked by other processes or blocking other processes, look at the Blocked By and Blocking columns.