Administration, BizTalk, Databases, Maintenance

BizTalk database sizing statistics

In the hope that this might help someone who is tasked to estimate the size of BizTalk Server 2006 databases, I’m offering a few statistics.


These statistics comes from an engagement that uses very few orchestrations and more or less does messaging only – ie do all the work in pipeline components and/or maps. Just to give you a hint of the volumes we are talking about – here are some numbers from the beginning of May:








































AvgRecvKB


AvgSndKB


Count


Month


Day


812 


7274 


476 


5


1


479


4111


1130


5


2


970


10877


444


5


3


680


10328


357


5


4


443


3288


1114


5


5


Now we have only been doing the volumes specified in the above table for roughly two months, before that is has been smaller but incrementally increasing (it would too drawn out to give the full story). I know that gives you a somewhat incomplete background, but that’s just how it is. Here are the sizes of the base BizTalk Server databases (all figures are in MB).


































Database


Data


Log


Total


Free


BAMPrimaryImport


655


380


1034


637


BizTalkMgmtDb


46


43


87


44


BizTalkMsgBoxDb


253


556


807


758


SSODB


13


13


25


15


I guess I should also mention that we have the BizTalk backup jobs doing full backups on a daily basis, as well as trasaction log backups every 20 minutes, and the DTA purge and archive setup for 12 live hours and 7 hard days. We have roughly about 300 receive ports, 1000 receive locations and 400 send ports and 20 or so orchestrations. Regular BizTalk Tracking hasn’t been globally turned off, but is at a basic minimum. A BAM Tracking component does the real tracking as far as monitoring goes.


Do you have any statistics that you could perhaps share with me?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s