Views:
  1. Have all users log out of GP.
  2. Run the following statements:

DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
DELETE DYNAMICS..ACTIVITY