 | Note: Ensure that you are logged in using the AgfaService account; you cannot log into Enterprise Manager 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 2005 database activities
Open SQL Server Management Studio.
In the Object Explorer window of SQL Server Management Studio, expand server > Management
where server is the name of the SQL Server that the program is running under.
Double-click Activity Monitor.
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.