Workflows are taking an extensive period of time to run. Pause actions specifically are taking extremely long time to execute.
Long workflow execution, specifically long Pause action execution, can often result from environmental issues (such as large Workflow History lists, and a large dbo.WorkflowProgress tables within the Nintex Content database) slowing the Workflow Timer Job execution. To determine if workflow execution is being stalled due to Nintex environmental issues, follow the steps below:
Check the dbo.WorkflowProgress table in the Nintex Content database associated with the SharePoint site via SQL Management Studio. If there is large amount of data in this table (8,000,000-15,000,000~ rows), purge some of the data from the database to prevent SQL from timing out at runtime. Run the NWAdmin operation ‘PurgeWorkflowData’ to accomplish this. Perform these actions during a maintenance window or off-peak time as they will place locks on the workflow progress table and can affect running and new workflows.