BizTalk database sizing statistics

Listen with webReader
Published 07 May 08 09:15 PM | Johan Hedberg

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?

Comments

No Comments

This Blog

News

    Messenger

    Twitter Updates

      Follow me on twitter

      Visitors

      Feedburner Subscribers

      Locations of visitors to this page

      Disclaimer

      All material is provided AS IS voiding any thinkable or unthinkable effect it might have for any use whatsoever. There... is that clear enough ;)

      Pages

    Syndication