How to Identify Bottlenecks in the BizTalkDTADb Database

To identify bottlenecks in the BizTalkDTADb database, perform the following steps:

  1. Ensure that the SQL-Agent Service is running.

  2. Ensure that the Archive/Purge Job is running and completing successfully.

  3. Verify that sufficient free disk space is available for the DTADb archives and database growth.