Viewing SQL Server Activity

Use the maintenance task Show SQL Server Activity to:

  • determine the cause when the SQL Server doesn't respond

  • check for any deadlocks

Follow the steps below to view SQL server activity.

View SQL server activity

  1. On the DWD Designer, click DWD Solution > Maintenance Tasks.
  2. Click Show SQL Server Activity in the Maintenance Tasks screen.