How to capture SqlWorkflowPersistenceService errors.

If you are failed to persist the workflow or read workflow information from the Database ,workflow runtime may raise Abort event or Terminated event without raising any error messages ,so if you got Abort event or Terminate event and if you don't know why workflow fired these events, Please enable workflow trace to debug these problems

How to enable workflow trace

https://blogs.msdn.com/madhuponduru/archive/2008/01/17/workflow-trace.aspx

You can find workflow FAQ here

https://forums.microsoft.com/msdn/ShowPost.aspx?PostID=2272219&SiteID=1&mode=1