Today I want to talk to you about two small optimizations often forgotten but with performance implications. Some of these implications may be noticed more in the early days of our BizTalk environment when the databases are small or almost empty and often need to increase, others can have impact later when databases are large and the percentage increase is also too large.

By default BizTalk Server databases are defined with small files size and with the parameter “Autogrowth” set to:

• Increase by 1 MB for database file
• And by 10% for log file

There’s a great post from Jeroen Hendriks: Checking database autogrowth settings where it is explained howwe can check allBizTalk Server database settings using an SQL query and also Database file size - data collection so that we can recommend the right values.