Examining the BAM database infrastructure
As impressive as all of this is so far (and recall that we're only scratching the surface), the real amazing part of it is the infrastructure which is automatically created and deployed for us.
If we open SQL Server Management Studio and look in the
BAMPrimaryImport database, we can see that the following tables were created for our tracking solution:
These tables hold the raw BAM data that is moved here by the BizTalk engine as it cleans out the message box and DTA databases. This also means that if a BizTalk environment is overloaded, ...