MBV BizTalk performance

http://blogs.biztalk360.com/biztalk-environment-maintenance-from-a-dba-perspective/
http://support.microsoft.com/kb/952555/en-us
http://biztalkadmin.com/orphaned-messages-in-the-tracking-database/

Violates Microsoft Policy:
USE [biztalkDTADb]
UPDATE [dbo].[dta_ServiceInstances]
SET [dtEndTime] = GetUTCDate()
WHERE dtEndTime is NULL AND [uidServiceInstanceId]
NOT IN(
SELECT [uidInstanceID]
FROM
BizTalkMsgBoxDb.[dbo].[Instances] WITH (NOLOCK)
UNION SELECT [StreamID]
FROM
BizTalkMsgBoxDb.[dbo].[TrackingData] WITH (NOLOCK))




http://msdn.microsoft.com/en-us/library/aa561960.aspx