How to Identify Bottlenecks in the BizTalkDTADb Database
To identify bottlenecks in the BizTalkDTADb database, perform the following steps:
Ensure that the SQL-Agent Service is running.
Ensure that the Archive/Purge Job is running and completing successfully.
Verify that sufficient free disk space is available for the DTADb archives and database growth.