Views:

To clear stuck jobs, do the following:

  1. Run the following commands:

    DELETE FROM managerjobs WHERE CompletedDate is null;
    DELETE FROM discoveryjobs;

  2. Restart both SQL service and DSM service.
 
Apply the sizing recommendation when deploying second node. It is also recommended to have the database on a different machine from DSM.