BizTalk Server 2006 (including R2 apparently – see warning section of this page) seems to have a bug, for which I’ve seen no fix, that affects the performance and size of the DTA (BizTalkDTADb) database because it fills it up with orphaned instances. You can detect these using the following query:

select count(*) from [dbo].[dta_ServiceInstances] […]